I'm searching for help in regards to alteryx workflow ,

kapilthakur

I have need to search for the data based on the date condition,

For example I have dataset which contains more than lakh records. In which I see that for some users the date is repeated twice and I have another column which is having different values for the same date. I wanted to neglect/remove the first occurance of date. 

In layman language

I'm trying to perform if date = date then Schedule= "WFH" else "Office" endif. 

Example 

Date                      Schedule         User 

6/7/23                  office               Harry 

6/7/23                  WFH                Harry 

7/7/23                  office               Harry 

8/7/23                  office               Harry 

9/7/23                  office               Harry 

output should look like.

6/7/23                  WFH                Harry 

7/7/23                  office               Harry 

8/7/23                  office               Harry 

9/7/23                  office               Harry 

Just wanted to compare date if it is repeating then need to remove first record.

Thanks in advance 

 

 

Qiu

@kapilthakur 
I will bring up my favorite tool "Tile".

For combination of User and Date, if there TileSequence is larger than 2 then we will remove the TileSequence 1.

0707-kapilthakur.yxmd