Alteryx Designer Desktop Discussions

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

Move one column value to a new column in a specific row using a formula

AKPWZ
8 - Asteroid

Hi everyone,
wanted to ask one thing that how we can move one column value to a new column in a specific row using a formula.

value.png

 As you can see this screenshot.
I have three column and I want to move the 'vid-offset' - json_value to a new column. (marked yellow)

I' using this formula but it's not working for me:
if [has_more]="true" then ([JSON_Name] = "vid-offset" AND [JSON_ValueString])
else Null()
endif

Please help me how I can do it. 

Thank you

2 REPLIES 2
dhrathod
7 - Meteor

Use Multi Row Formula

if [has_more] = "True" and [Row+1:JSON_Name] = "vid-offset" then [Row+1:JSON_valueString] else null() endif

AKPWZ
8 - Asteroid

Yes @dhrathod  I did the same thing using Multi-Row formula. Thank you 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels