Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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