Return String in list of directories

[nsarayar]

Hi

Could someone tell me how I can extract and return the FY and Q information for each file in a directory. So i need to return "FY19 Q2", "FY19 Q3", etc

Thanks

[cmcclellan · Accepted solution]

I'd use a REGEX tool configured like this:

The Regular Expression itself is just 

FY\d\d Q\d

meaning FY then 2 numbers, a space then Q and another number.

The tool will create a new column with the details that you require from the filename.

[sumitiiest · Accepted solution]

Hi @nsarayar ,

Please find attached the Alteryx workflow which will extract the year and quarter portion from the directory.

I have used below formula to calculate this

Cheers,

Sumit

[nsarayar]

Thank you both for your help and suggested solutions