We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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