Date Compassion - Sequential Generation

[AlteryxUserFL]

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? 

User	Access Level	Approved Date
UserA	5	01/01/2019
UserB	2	01/02/2019
UserC	3	01/02/2019
UserA	1	01/03/2019

Date	User	Level
01/01/2019	UserA	5
01/01/2019	UserB	0
01/01/2019	UserC	0
01/02/2019	UserA	1
01/02/2019	UserB	2
01/02/2019	UserC	3
01/03/2019	UserA	5
01/03/2019	UserB	2
01/03/2019	UserC	3

[MarqueeCrew · Accepted solution]

@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