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

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