Dynamic Dates

[micky01]

IN my text input tool example i have a two sets of Data one for

31-10-2020 - Month end data for October.
29-11-2020 - Daily Data.

What i have done so far is i have read these two files in my workflow using a macro since the schema is
different.

What i want to achieve is i want to count the Unique MC ID's against current Date(29-11-2020) with
previous month end Data(31-10-2020.

Also wanted to make this Dynamic daily so if the Daily data file for tomorrow (30-11-2020)comes in i
want to count the MC IDs for ( 30-11-2020) with previous month end data (31-10-2020).

On my final output i want to display all the MC IDs with the count for daily and previous month end data.

Any thoughts on how to achieve this also I have attached the workflow with the sample Data.

[PhilipMannering]

Hi @micky01,

I'm afraid I'm not 100% clear what you're after. And judging by the lack of response I'm not alone.

I've had a stab at it. Take a look and let me know where I've gone wrong (I split up month end and daily as it seemed to make more sense). Specifically, if you provide the expected output it would help a lot.

Thanks,

Phil

[micky01]

Hello,

Sorry my apologize.

In my example I have read  the Daily Data with Previous month end Data already I have just taken a count of MC ids in my example just as starting point.

Say in your workflow out put you have three columns as below.

ID's

Count of previous month end data =  On this column header I want the Date to be 31-10-2020

Count of daily data =  On this Column header I want the Date to be  29-11-2020.

I want this to be Dynamic Say  when I receive the file on 30-11-2020 I want the column header to change to 30-11-2020 along with 30-10-2020.

Hope this makes sense now.

Apologize again.

[Qiu]

@micky01 
From the work of @PhilipMannering, I use Dynamic Rename to get what you need, I hope.

[deafening_silence]

Hi

Not sure if I understood the problem correctly, but still trying.  Are you looking for output like below?  Please note, I added some extra rows to check the dynamic nature of the logic and also changed the format of the date to have them arranged chronologically. 

Best Regards

Constant Variable