Hello everyone,
Starting from a dataset where I have “Start_Date” (DD/MM/YY), “End_Date”(DD/MM/YY), “Frequency” (Monthly or Weekly) and “execution day” (MO,TU,WE,TH,FR,SA,SU).
How can I obtain from a single record, many records for each date of execution of the service?
I’m trying to use “Data&Time Shift” Node, but what i need is different, because for a single record, I would need to have as many records as the execution dates (also specifying the exact date DD/MM/YY).
@albertoruggeri1
It’s always a good idea to post sample data and/or a workflow for the community to better understand and help.
You might want to check out create date time range node or one row to many with additional datetime shift or math operations
br
@albertoruggeri1 question is what exactly you are expect ting as a result. One option is to employ Python and ChatGPT to generate the data you (might) want. This will create the Execution_days per line, start at the first weekday within you range and run until the end is reached:
