ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Inserting row above dataset

wonka1234
Bola de fuego

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

Hi @wonka1234 

 

One way of doing this

 

Workflow

Felipe_Ribeir0_1-1672779348807.png

 

 

Excel Output

Felipe_Ribeir0_0-1672779339178.png

 

 

wonka1234
Bola de fuego

@Felipe_Ribeir0  is it possbile to do this without headers? 

Like this?

Felipe_Ribeir0_0-1672779573949.png

 

Just delete the multi field part

 

Felipe_Ribeir0_1-1672779597739.png

 

 

wonka1234
Bola de fuego

@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

Hi @wonka1234 

 

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

 

Felipe_Ribeir0_1-1672781252846.png

 

wonka1234
Bola de fuego

@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?

 

 

 

@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

 

Etiquetas
Autores con mayor cantidad de soluciones