Select dynamic columns

Question

Hi all, I am creating a workflow using an external excel. The original excel has rows with dates. Dates change everyday (we always have a new day in the excel). I need to convert that data in columns and the workflow must select all days dynamically. I should have one column for each day. Please advise, thank you so much for the help!

Original excel:

Dateamount01-Aug-202240001-Aug-202230002-Aug-20225008-Aug-202250008-Aug-2022100

What is needed:

01-Aug-202202-Aug-202208-Aug-202270050600

DataNath · Answer

@Camiiara in the Dynamic Rename tool, just make sure you have Dynamic or Unknown Fields selected. That way, if you add more dates, this applies the Formula to extra fields that pop up. As shown here - I've manually added data for 15-Sep-2022 to the Text Input without touching anything else and the change automatically carries through:

The Summarize beforehand isn't necessary as this is just used to aggregate which you need to do within the Cross-Tab tool itself anyway.

Camiiara · Answer

thank you so much! quick question. i tried to do it but if  i have new dates everyday, they do not appear automatically. Only dates that i have selected on summarize tool. How can i do it? thanks!

Camiiara · Answer

Hey. thank you so much. Could you please help me with the configuration of Dynamic rename tool? in order to select all dates automatically (everyday dates change)