CSV Output with 2 rows of header

[derZabel]

Hi,

So far, I could find answers to all my questions in the Community, but now I came to a point where I need help. I tested some variants without success. Thank you very much in advance.

Output should be a .csv file (as quick-fix, a txt or word output could work i.e. copy & paste of the actual output to a clear .csv should work).

The .csv needs to have the following format - the first two rows come from the text input and are "static". Please note that the first row has a ";" whereas the second not, which creates an issue I think. However, e-mail address is optional, so I could just disregards this (and end up with a “;” in the end).

Data seems to be ok, but I not get the header working. I tried with blank table headers without a positive result.

SKV574008;

556000016701;1001;Per Persson;0123-45690;post@filmkopia.se

FI01409351;16400;;;

DK31283522;21700;13600;;

 

PS: I also do not get the multi field formula working (round to full amounts). It works with the general formula tool.

[Thableaus]

Hi @derZabel 

I'd like to understand a little bit better your scenario.

"The .csv needs to have the following format - the first two rows come from the text input and are "static"" - There's just one row in the text input of your workflow. What is the second row you're talking about?

I'd suggest you to concatenate the fields in a Row with ";" separator  and then use \0 delimiter to create the csv. Also, the Round formula should be this one
Round([_CurrentField_], 1)

Cheers,

[derZabel]

The first and second row are marked in red and must excactly look like the red text when exporting.

No change in the first row. Therefore, I tried to put it as header of the table. The Second row comes from the text input because here I would like to update the period.

[derZabel]

Tanks, I got your point - I removed the header in the output tool and created both rows via the text input.

Now I get this. Is there a way to get rid of the red-marked items? They come with the output....

---

SKV574008;;;
"556000016701;1001;Per Persson;0123-45690;post@filmkopia.se";;;
IE9952013338J;2913;9923;
IE995230418J;1279;;3434
IT02050461207;-13122;;
NL8057349583B01;;324;
NL8057349584B01;230;324;233
NL8057349584B01;;;445

[Thableaus · Accepted solution]

Hey @derZabel 

Here's the solution I came up with.

Change inputs and outputs to your file paths, please.

Cheers,

[derZabel]

Nice, thanks, I put a select tool to remove the red items below - that should work. I need test more with record ID it solves a lot. Have a nice evening. 

SKV574008;Goods;Triangulation;Services
556000016701;1001;Per Persson;0123-45690;post@filmkopia.se
IE9952013338J;2913;9923;