Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Col Comparison

Highlighted
7 - Meteor

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

Highlighted
Alteryx Partner

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

 

[Row-1:current]

Highlighted
7 - Meteor

Thanks!! 

 currprior
day110
day 2 ??1

 

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

Highlighted
Alteryx Partner

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.

 

 

Highlighted
7 - Meteor

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

Highlighted
Alteryx Partner

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 ?

Highlighted
7 - Meteor

Attaching my wf . i need my results like below

 cwpw
day 110
day 211
day 31 

 

 

Highlighted
Alteryx Partner

So something like this ?

 

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

Highlighted
7 - Meteor

 

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 ??

Highlighted
Alteryx Partner

What is the logic behind Day 4 being 0 though ?

Labels