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