Hello,
I have a per second data for each day and I would like to define a condition where any row which falls on a "Friday 12 am to 3pm" should be removed.
Can you please tell how can I achieve this in alteryx?
I have tried a lot of datetime functions and nothing seems to be working.
Thank you
Regards,
Pankhudri
Solved! Go to Solution.
Hello,
Thank you everyone for the prompt solutions.
It worked perfectly.
Regards,
Pankhudri
Hello @HomesickSurfer
I accepted the solutions which worked.
However, I have another query regarding date.
I need to load files from a folder where files are generated daily and the file name contains the date it is generated. I need to load the files from 1st June 2021. Can you tell me how can I specify this date to load files?
Thank you
Regards,
Pankhudri
Hi @Pankhudri20
Use a directory tool first.
It will list the files in the folder.
Then filter the records by Filename containing the date you require.
Once you have the filterred files identified, feed the FullPath+"|||"+Sheetname as a new field in a formula tool into a Dynamic Input tool, using 1 of your desired files as your data input template.
Hello @HomesickSurfer ,
Thank you for your response!
How can I filter if I want all the files after 1st June?
Is there an example I can refer to ?
It would be a great help.
Thank you
Regards,
Pankhudri Agrawal
Hi @Pankhudri20
Does the filename have the dates or is it last modified date of the file that you want to filter on.
Hello @atcodedog05
Yes, the filename has dates.
I need to load files from June 1st 2021 and continue for all the later months.
If I specify 06 in file specification, it will only load june files always.
Regards,
Pankhudri