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

Col Comparison

geeksqaud
8 - Asteroid

Hi ,

 

I Have a requirement where i need to compare values across columns .

The value for Day 2 is populating from Day 1 "Current" column and like wise 

The value for Day 3 prior is populating from Day 2 "current" columns like wise 

The value for Day 4 is populating from Day 3 "current" columns like wise

 

 priorcurrent
day 1 1
211
311
411
511
611
711
811
91 

 

really appreciate your help .

 

Thanks,

GS

9 REPLIES 9
cmcclellan
14 - Magnetar

Just use a Multi-Row Formula,  where Prior (possibly a new column being created in the tool) is simply:

 

[Row-1:current]

geeksqaud
8 - Asteroid

Thanks!! 

 currprior
day110
day 2 ??1

 

How do I populate 1 from prior to curr column ??

cmcclellan
14 - Magnetar

Hmmm OK, if you want to populate Day 2 Current from Day 2 Prior then a Formula Tool after the Multi-Row would do that.

 

 

geeksqaud
8 - Asteroid

Not sure what I am missing. But it is not working :(

cmcclellan
14 - Magnetar

Can you provide a XLS of what you're starting with and what you want at the end ?

 

Or a workflow of what you have so far ?

geeksqaud
8 - Asteroid

Attaching my wf . i need my results like below

 cwpw
day 110
day 211
day 31 

 

 

cmcclellan
14 - Magnetar

So something like this ?

 

2019-01-23 12_31_54-Alteryx Designer x64 - BLOG.yxmd.png

geeksqaud
8 - Asteroid

 

Thanks a lot!!!!  i really appreciate this . 

 

dateCWPW
day 1 10
day 211
day 311
day 401

How do i get the last record  day 4 -cw  as 0 ??

cmcclellan
14 - Magnetar

What is the logic behind Day 4 being 0 though ?

Labels
Top Solution Authors