Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

CSV Output with 2 rows of header

derZabel
7 - Meteor

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;;

 

 Capture.JPG

 

 

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

5 REPLIES 5
Thableaus
17 - Castor
17 - Castor

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
7 - Meteor

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
7 - Meteor

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
17 - Castor
17 - Castor

Hey @derZabel 

 

Here's the solution I came up with.

 

Solution.PNG

Change inputs and outputs to your file paths, please.

 

Cheers,

derZabel
7 - Meteor

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;

Labels