Multiple IF condition for Date and time

@Pankhudri20 fyi - my formula - uses !="friday" so therefore any record with a time after 3 pm. or not a Friday will be "TRUE" and the removed records (Friday 0-15) will be "False"... It usually helps to keep the removed records in the false side of the anchor... If you wanted it to the other side you can use ="Friday" and replace "Or" with "And"

HomesickSurfer

@Pankhudri20

My approach below and workflow attached.

I've added the following to your sample data and worked great to remove the first 3.

7/23/2021 12:00:01 AM
7/23/2021 2:59:59 PM
7/23/2021 3:00:00 PM
7/23/2021 3:00:01 PM

Pankhurdri20.yxmd

Sample_downtimedates.xlsx

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.

New Workflow11.yxmd

atcodedog05

Hi @Pankhudri20

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

Pankhudri20

Hi @atcodedog05

The file name looks like this:

"Analytics-Data-2021-05-11-00-00-00.csv"

"Analytics-Data-":this is constant

2021: year

05: month

11: day

apathetichell

post screengrabs of your action tool and the formal tool it's leading into... @atcodedog05 's solution should work for you.

basically formula should be set up as:

"Analytics-Data-"+datetimeformat("2021-05-11 00:00:00","%Y-%m-%d-%H-%M-%S")+".csv"

and action tool should be set up to replace specific string... specific string has to be:

2021-05-11 - date tool put in a date - not a datetime... so the time component of your .csv file name will be static.

Didnt' you already get an answer to your original question btw? You should mark it and start a new thread.

Pankhudri20

Hello @apathetichell

Thank you for your response.

I marked the solutions for the initial questions. I asked another questions here since it was datetime related.

I will open a new thread.

Regards,

Pankhudri

atcodedog05

Hi @Pankhudri20

Here is how you can do it.

Workflow:

1. Using directory to point to the location with all file and get their info.

2. Using formula tool to extract date from filename.

3. Using filter tool to keep only files from 1st June.

4. Read these files using dynamic input tool.

Refer to the initial part of the video to understand more on dynamic input tool https://www.youtube.com/watch?v=ELfKYatOJZM

Hope this helps : )

Read only from 1st june.yxmd

Analytics-Data-2021-05-11-00-00-00.csv

Analytics-Data-2021-06-11-00-00-00.csv

Analytics-Data-2021-07-11-00-00-00.csv

Analytics-Data-2021-08-11-00-00-00.csv

Pankhudri20

Hello @atcodedog05 ,

Thank you for your response.

I will check the workflow.

Regards,

Pankhudri

apathetichell

@atcodedog05I think the dates follow standard Alteryx date-time so "2021-05-11" is the date... no idea what 1-11 and 13-22 are

atcodedog05

Kind of agree @apathetichell may be the case. Just want to be sure🤔

Hi @Pankhudri20,

If the date in new filenames is 2021-05-11. The above same approach should work.

Hope this helps : )

Pankhudri20

Hello,

Thank you for your response!

The dates are the same as before. Everyday 2 files are generated.

Analytics-Data 1-11-2021-05-11-00-00-00.csv

Analytics-Data 13-22-2021-05-11-00-00-00.csv

Analytics-Data 1-11-2021-06-11-00-00-00.csv

Analytics-Data 13-22-2021-06-11-00-00-00.csv

Analytics-Data 1-11-2021-07-11-00-00-00.csv

Analytics-Data 13-22-2021-07-11-00-00-00.csv

The only thing that changes in the filename is the date.

I want to load 1-11- and 13-22- in 2 separate workflows.

With the above solution it will load all the files and increase loadtime.

So how can I specify 1-11- or 13-22- in the regex formula?

Hope this helps.

Thank you

Regards,

Pankhudri

atcodedog05

Hi @Pankhudri20

You can regex like below to capture the filename.

REGEX_Replace([FileName],".*(\d{1,2}-\d{2})-\d{4}-\d{2}-\d{2}.*","$1")

Workflow:

Hope this helps : )

Read only from 1st june.yxmd

Analytics-Data-2021-06-11-00-00-00.csv

Analytics-Data-2021-05-11-00-00-00.csv

Pankhudri20

So will it capture both '1-11-' and '13-22-' types of files?

I want to capture only '1-11-' in one workflow and '13-22-' in another workflow.

Regards,

Pankhudri

atcodedog05

Hi @Pankhudri20

Yes, use a filter to isolate to a specific type similar to filtering filenames after 1st June.

Pankhudri20

Hello @atcodedog05 ,

I am sorry for troubling so much!

Since I am new to Regex expressions, I used this expression in the Categorize and it is working perfectly for 1-11 but not retrieving any files when I choose 13-22.

REGEX_Replace([FileName],".*(\d{1,2}-\d{2})-\d{4}-\d{2}-\d{2}.*","$1"

Can you please tell me if any change is required in the expression for 13-22?

I tried changing the expression but it is not taking 13-22.

Any help would be really appreciated.

Thank you

Regards,

Pankhudri Agrawal

apathetichell

assuming 13-22 files have the same structural components as 1-11 - the regex should be the same... is the "-" there and does the date in yyyy-mm-dd follow 13-22? are there any numbers before that 13?