Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Want to add a null value to the first row column and create a new column

PNC97
8 - Asteroid

I had the rows like this 

Prudhvinath_Chowdary_0-1622752208274.png

 

The highlighted need to be my output.

 

Thanks for help

2 REPLIES 2
MattBSlalom
11 - Bolide

This question is a little vague.  You could simply Union a null() row with your source "Merged" column to get the highlighted result... but I think you're wanting to use the Index fields to lookup the "Merged" value from the row that matches the 2nd index field.  If that's the case, you need a Join tool plus a Union tool to capture the output from the different anchors to carry forward the unmatched / null value.

 

Sample workflow below & attached.

MattBSlalom_0-1622754526370.png

 

PNC97
8 - Asteroid

You Saved my Day 🙂

Labels
Top Solution Authors