Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 

Labels