Alteryx Designer Desktop Discussions

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

Adding two rows to an output file above the headers

theamandagail
6 - Meteoroid

Hello,

 

I produced a file with headers and values. I want to insert two rows above the headers with a different set of headers and values. How would I do that? 

 

I tried to create a Text to Value input and then UNION with the output file but it just added to the headers on the right, not above.

 

See expected file attached as well as the actual file

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @theamandagail 

 

Configure it to write to a range like below.

 

atcodedog05_0-1648145372295.png

 

You can set the range in this window

atcodedog05_1-1648145411586.png

 

This way both tables are written into separate ranges one above the other.

 

Hope this helps : )

binuacs
20 - Arcturus

@theamandagail the union tool also should work  

binuacs_0-1648193143051.png

 

theamandagail
6 - Meteoroid

This worked! Thank you!!! 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @theamandagail 

Cheers and have a nice day!

Labels