How to alternate records from two datasets by EEID in Alteryx

[Navyasree123]

Hello All, Hope you all doing great,

could you please help me out this query please

I have two datasets, one with E records and one with D records. Both have the same EEID field, and some EEIDs appear multiple times in each dataset. I want to combine them so that for each EEID, the records appear in an alternating order — E, D, E, D — without mixing EEIDs. and also I have attached the file and workflow that i have worked.

Thanks in advance!

[Qiu]

@Navyasree123 
I dont see "EEID", you mean "PPN"?
It is better you can provide a sample output. 😁

[Navyasree123]

Hey @21 - Polaris ,

Thanks for the Reply,I have attached the sample output below could you please check.

[Gaurav_Dhama_]

In your original workflow, add another layer of sort on new > ascending.

Result:

[Navyasree123]

@Gaurav_Dhama_,

It seems to be working only for the first few records.I have also tried the approach in the way you suggested,but I'm still facing the same issue.Thank you!

[Gaurav_Dhama_ · Accepted solution]

Check out the attached workflow, I have used tile instead of record id to group the items together.

[Navyasree123]

Thanks a lot for your help,It is working perfectly now.