Alteryx Designer Desktop Discussions

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

How to add a null row to an existing column

PNC97
8 - Asteroid

Hello all,

 

I have an existing column 

 

Merged
1
1
2
2
3
3
4
4
5

 

I want to add a null value to the head of this row 

 

Expected output

 

Merged.1
Null
1
1
2
2
3
3
4
4
5

 

 

Thanks in advance

3 REPLIES 3
BrandonB
Alteryx
Alteryx

You can create a null row in a text input and then union the two streams together and check the box at the bottom of the union configuration so that the text input data set comes first.

PNC97
8 - Asteroid

@BrandonB 

 

If possible can you send me a workflow as I'm a newbie 

It will be so much helpful

BrandonB
Alteryx
Alteryx

It will look like this

 

BrandonB_0-1622750384092.png

 

Labels