Adding fields in the Excel input from the file name

[Abhii2658]

I have 20 files to input in my Alteryx. Their file names follow a pattern 

FileNames

A2A_S10_050

A2A_S43_070

A2A_S70 010

A2A_S20 030

When the workflow is run, i need to add 2 fields Field A and Field B based on these names such s 

    File Names    Field A   Field B

A2A_S10_050       10           50 

A2A_S43_070       43           70

A2A_S70 010        70           10

A2A_S20 030        20           30

A2A_S55               55           10 (If only first number is present then Field B is defaulted to 10)

Regards 

Abhijeet 

[AkimasaKajitani · Accepted solution]

Hi @Abhii2658 

In this case, you can use the "Output File Names as Field" option of Input Data tool.

After that, you can use the FileName field into desired output.

So I made 2 workflow. One is the easy another one is simple but difficult.

Please check the attached file. If you have any question, let me know.

[Abhii2658]

@AkimasaKajitani sorry about the late response, thank you for the solution.