Alteryx Designer Desktop Discussions

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

How to output table data to csv file with file name based on a atribute of the table

NicoLehmann
6 - Meteoroid

I have as input some data coming from sap. the final table is looking like that:

Screenshot 2023-09-24 180741.png

I want now to create/ replace a csv File to a network drive. The Filename schould be the Bom_Header (field of the table).

How to do that?

 

 

2 REPLIES 2
FrederikE
13 - Pulsar
 

Hey @NicoLehmann,

 

In the Output tool you do have the option to select a field to append the Name from. Select the field there. 

 

 

Unbenannt.png

gawa
15 - Aurora
15 - Aurora

hi @NicoLehmann 

 

First, create fila path by Formula tool with expression like "\\machin001\\yourfolder\"+[BOM_HEADER]+".csv".

And check option of "Take FIle/Table Name Field" in output tool, and select option "Change Entire File Path", and specify the filed name you created in Formula tool, then you can dynamically change output file path.

image.png

Labels