Alteryx Designer Discussions

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

Add another row with merged column names/or empty row

joannasokolowska
8 - Asteroid

Hey,

I need your advice regarding below case. 

 

1. This is what I have in the output excel file

joannasokolowska_0-1614792008242.png

 

2. This is what I would like to have in the output file (merged rows above column names ) or have the first row empty so other system can start uploading data from exact row number

 

joannasokolowska_1-1614792159890.png

 

Best,

Asia

 

 

 

 

 

 

11 REPLIES 11
ImadZidan
12 - Quasar

Hello @joannasokolowska ,

 

Please have a look at this. I feel its a bit too much but I will give it a think tonight.

try it and if it works we try to make it more efficient. This will also give you an idea.

joannasokolowska
8 - Asteroid

Hey,

I simplified the workflow and it works as attached 🙂 

 

Thank for the inspiration 🙂 

Labels