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

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