Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Adding fields in the Excel input from the file name

Abhii2658
8 - Asteroid

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 

2 REPLIES 2
AkimasaKajitani
17 - Castor
17 - Castor

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.

 

AkimasaKajitani_3-1628829282982.png

 

 

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

 

AkimasaKajitani_2-1628829250792.png

 

 

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

 

Abhii2658
8 - Asteroid

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

Labels
Top Solution Authors