Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!

Alteryx Designer Desktop Discussions

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

Inserting row above dataset

wonka1234
10 - Fireball

Hi,

 

I have a row i want to insert into the top of my dataset.

 

wonka1234_0-1672778898999.png

 

 

How can I insert this at the top like so?

 

Important Note: blah blah blah  
Header1Header2Header3
Data1Data2Data3
7 REPLIES 7
Felipe_Ribeir0
16 - Nebula

Hi @wonka1234 

 

One way of doing this

 

Workflow

Felipe_Ribeir0_1-1672779348807.png

 

 

Excel Output

Felipe_Ribeir0_0-1672779339178.png

 

 

wonka1234
10 - Fireball

@Felipe_Ribeir0  is it possbile to do this without headers? 

Felipe_Ribeir0
16 - Nebula

Like this?

Felipe_Ribeir0_0-1672779573949.png

 

Just delete the multi field part

 

Felipe_Ribeir0_1-1672779597739.png

 

 

wonka1234
10 - Fireball

@Felipe_Ribeir0 

wonka1234_0-1672780948348.png

My cycle column isnt beneated my field1..

 

I want my excel to look like

 

Important Note: Blah

 
CycleCycle2
datadata
datadata
Felipe_Ribeir0
16 - Nebula

Hi @wonka1234 

 

Please note that the union tool must be configured to Auto Config by Position:

 

Felipe_Ribeir0_1-1672781252846.png

 

wonka1234
10 - Fireball

@Felipe_Ribeir0 

 

I have a field that seems to be parsed by your multi field formula tools.

 

wonka1234_0-1672783526387.png

wonka1234_1-1672783537878.png

 

why is this?

 

 

 

Felipe_Ribeir0
16 - Nebula

@wonka1234 

 

Inside of the multi field formula, change this Size value to a bigger value. It must be bigger/equal than the max length character of your fields.

Felipe_Ribeir0_0-1672783629041.png

 

Labels
Top Solution Authors