Help with extraction: Data extraction previous month

[quintin1009]

Hi!
New to the KNIME community.

I am trying to extract data from the previous month so I can limit the size of the output and give an update on the month performance. It seems quite easy for my understanding but I can’t figure it out unfortunately. Could someone help me maybe?
Date= yyyy-mm-dd

I only got to use day of today, but that should be between start month <> end month

Thanks!

[rfeigel]

Welcome to the KNIME community.
A few questions:

1. Is your data cumulative and dynamic, i.e. constantly updated?
2. Does your data cross years?
3. If you want the previous month’s data why do you have a node which backs up
   2 months?
   
   
   
   It would be helpful if you could share a sample data set, anonymized if necessary.

[quintin1009]

Hi Rfeigel,

The data is dynamic, so each month the scan data is added to the folder, which will be read by Knime.
2. for the time being this is only 2024 yet but will effect also the following years.
3. Typo mistake and took it over from a previous discussion from knime.

I have currently 919270 rows, which I hope to limit in a monthly data range.

I thought that the sample data set would help from this article on knime.

Filter Out only whats two months old

I am trying to filter only what is two months old from the day I am running my workflow to the beginning of the month 2 months ago (for example: today is February 9th, 2022 and I’d require data until December 1st, 2021) I am attaching my workflow that so far has: 02 Months Old.knwf (145.8 KB) [WmgRa8V5Ld] An example of the data set I am using and I was able to pull the year, month, and day separately. Things I’ve tried: First I thought that I could take today’s date and count how many day…

[rfeigel]

I think @bruno29a’s workflow can be modified to work for you. It would be very helpful if you would share your data since it has current dates.

[rfeigel]

Try this. I did this without knowing exactly how your table is formatted.
1 Month Prior Date Filter.knwf (112.2 KB)

[quintin1009]

Hi @rfeigel,

Thanks for the workflow, it works perfectly!

Kind regards

Quintin

[quintin1009]

Hi @rfeigel,

Question related to the topic. Let’s say we will only use previous month when data is available, otherwise keep using the month before? I see that now in December, it requires the data of November, which is not available yet (delay). How could I change the rule which will give the latest available data? I think now it will add both months when available?

[rfeigel]

Here’s a quick and dirty solution. It does require human intervention. If the previous month’s data is not available, it backs up two months. Writes an output file to the data area of the workflow.
1 Month Prior Date Filter rev 1.knwf (134.2 KB)

[rfeigel]

Did my last workflow work for you?

[quintin1009]

Hi rfeigel,

I did test it, but the manual step does not work for me. I am now checking whether IF option or Case would work for me.

[rfeigel]

If you haven’t solved the problem try this. It has two test data sets. One with previous month and one back two months. If you solved another way, please post to help the community.

1 Month Prior Date Filter rev 3 – rfeigel