Multiple IF condition for Date and time

[Pankhudri20]

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 

[Pankhudri20]

Hello,

Thank you everyone for the prompt solutions.

It worked perfectly.

Regards,

Pankhudri

[HomesickSurfer]

Hi @Pankhudri20 

Which proposed solution works best for you, if not All?

[Pankhudri20]

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

[HomesickSurfer]

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.

[Pankhudri20]

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

[atcodedog05]

Hi @Pankhudri20 

Does the filename have the dates or is it last modified date of the file that you want to filter on.

[HomesickSurfer]

Hi @Pankhudri20 

Try this.  Sample workflow attached.

[Pankhudri20]

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

[Pankhudri20]

Hello @HomesickSurfer 

Thank you.

I will try this workflow.

Regards,

Pankhudri

[atcodedog05]

Hi @Pankhudri20 

Can you provide us how your filename looks like. So that we can build accordingly 🙂