Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Date Compassion - Sequential Generation

AlteryxUserFL
11 - Bolide

I have two tables I need to compare. One table shows a list of users, the date the user was approved or changed, and their new or updated access level. I want to compare that to another table that shows the access level of each user every day. I'm looking to find any differences. I figure the best way to do that would be to sequentially generate a list of access levels between each change on table A and then join the two tables. Any ideas on how to do that? 

 

UserAccess LevelApproved Date 
UserA501/01/2019
UserB201/02/2019
UserC301/02/2019
UserA101/03/2019

 

 

 

DateUserLevel
01/01/2019UserA5
01/01/2019UserB0
01/01/2019UserC0
01/02/2019UserA1
01/02/2019UserB2
01/02/2019UserC3
01/03/2019UserA5
01/03/2019UserB2
01/03/2019UserC3

   

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@AlteryxUserFL ,

 

I would use the 2nd table to try to create the first table.  One challenge is to convert your "date" field into an ISO-DATE format:

 

DateTimeParse(date,"%m/%d/%Y")

Doing this transform you'll now be able to sort the dates and group them properly.

 

Your level 0 I assume is a placeholder, so drop them in a filter.  There is a data issue in that UserA has an access level of 1 on 01/02/2019.  Maybe that is a test?

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels