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.
SOLVED

Move Values Down

Ahmediqbal
7 - Meteor

Hello, 
I'm at a roadblock, and I need help, please. I have two files that I need to match. However, I need to move the values down in column "To Match File" if column "Taxable Export File" contains "Federal $1 mil". The values need to be moved to the next category, for instance,
from Tax Description 2 to Tax Description 3 and,
Taxable Gain 2 to Taxable Gain 3 and,
Taxable Rate 2 to Taxable Rate 3 and 
Taxable Amount 2 to Taxable Amount 3. 

I have attached the same data. Please let me know if you have any further questions. Thank you!

Ahmediqbal_0-1665992964706.png

 

1 REPLY 1
Emmanuel_G
13 - Pulsar

@Ahmediqbal 

 

I've just did a test with this sample of data. It's ok for most lines.

 

However, I found lines that doesn't follow your logic in your Excepted output.

 

For example : On the Taxable description 8, why do you take the value of 7704.36 which is Tax amount 7 instead of Tax description 7 ( Canada-BC ) ?

 

Find in attachement my test with the logic of your instance.

 

Emmanuel_G_0-1665999901936.png

 

Labels
Top Solution Authors