We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

rename columns

adampolcz
6 - Meteoroid

I was able to dynamically select the columns I need but now I need to use a formula tool which makes a new column and its value is based on the last 2 columns. But since I don't know it's names how can I say: get the value of the last column minus the value of the column 2 to the left? 

2 REPLIES 2
binuacs
21 - Polaris

@adampolcz @Can you provide a sample input file and expected result based for better understanding of your use-case

adampolcz
6 - Meteoroid

I was able to manage this with python tool, thanks!

Labels
Top Solution Authors