Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors