SAP requires weird format for upload

[raphael_illi]

Dear all,
for a customized upload program within SAP the following format for the txt file is required:

my workflow creates the proper table starting row 6. how can I add the first strange 5 rows within my knime workflow?

[ipazin]

Hello @raphael_illi,

and welcome to KNIME Community!

Can you create first 5 rows in a different flow (same workflow) and before writing it out use Concatenate node to bring it together?

Br,
Ivan

[raphael_illi]

Thank you @ipazin
i could almost create everything with “table creator”.

two questions:
how can I add the current date as a variable in the two red circled fields?

how can I concatenate rows? (I need the first table on top of the other)

BR,
Raphael

[ipazin]

Hello @raphael_illi,

table Creator node seems right way to go. To add date to specific cell in a column I would make use of ROWINDEX in Rule Engine node to match row you want. You’ll have to use one Rule Engine for each column. In order for to get format you need (first table on top of the other) columns names need to be same.

Br,
Ivan