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

Question

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

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?

Gawa · Answer

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.

FrederikE · Answer

Hey @NicoLehmann,

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