How to alternate records from two datasets by EEID in Alteryx

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!

Arrange.xlsx

Arrange workflow.yxmd

Macros

Accepted answers

Gaurav_Dhama_

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

Arrange workflow.yxmd

All comments

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.

Arrange.xlsx

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!

output.xlsx

Gaurav_Dhama_

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

Arrange workflow.yxmd

Navyasree123

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703