Hi, I've a dataset with three fields ID, Team , Order Number. Now I am trying to build a 'case flow' based on how the 'Team' changes for each ID. Below is the sample data IDTeamOrder Number5005b00001ISpPKAA1 15005b00001ISpPKAA1Network25005b00001ISpPKAA1PDS35005b00001ISpPKAA1PDS45005b00001ISpPKAA1PDIU55005b00001ISpPKAA1PDIU65005b00001ISpPKAA1PDS75005b00001ISpPKAA1Network85005b00001ISpPKAA1PDS95005b00001ISpPKAA1PDIU105005b00001ISpPKAA1PDIU115005b00001ISpPKAA1PDS125005b00001ISpPKAA1Network135005b00001ISpPKAA1PDS145005b00001ItbDKAAZ 15005b00001ItbDKAAZNetwork25005b00001ItbDKAAZPDS35005b00001ItbDKAAZPDS45005b00001ItbDKAAZPDS55005b00001ItbDKAAZPDS65005b00001ItbDKAAZNetwork75005b00001ItbDKAAZPDS85005b00001ItbDKAAZNetwork95005b00001ItbDKAAZPDS10 By using a cross tab I was able to transform data as below. IDMax_Order Number12345678910111213145005b00001ISpPKAA114 NetworkPDSPDSPDIUPDIUPDSNetworkPDSPDIUPDIUPDSNetworkPDS5005b00001ItbDKAAZ10 NetworkPDSPDSPDSPDSNetworkPDSNetworkPDS 5005b00001JxBz9AAF8 NetworkPDSPDSNetworkPDSNetworkPDS My question is I need write a condition to show the flow for each ID only when the team in the subsequent field changes. The number of fields for Each Id is shown by Max Order Number. Below is the expected Outcome IDMax_Order NumberCase Flow5005b00001ISpPKAA114Network-PDS-PDIU-PDS-Network-PDS-PDIU-PDS-Network5005b00001ItbDKAAZ10Network-PDS-Network-PDS-Network-PDS5005b00001JxBz9AAF8Network-PDS-Network-PDS-Network-PDS I have uploaded the data in the file. Any help is much appreciated . Thank you, Digvijay Question_Condition.yxmd

Conditional While Statement Based on Total No of Fields

Hi,

I've a dataset with three fields ID, Team , Order Number.

Now I am trying to build a 'case flow' based on how the 'Team' changes for each ID.

Below is the sample data

ID	Team	Order Number
5005b00001ISpPKAA1		1
5005b00001ISpPKAA1	Network	2
5005b00001ISpPKAA1	PDS	3
5005b00001ISpPKAA1	PDS	4
5005b00001ISpPKAA1	PDIU	5
5005b00001ISpPKAA1	PDIU	6
5005b00001ISpPKAA1	PDS	7
5005b00001ISpPKAA1	Network	8
5005b00001ISpPKAA1	PDS	9
5005b00001ISpPKAA1	PDIU	10
5005b00001ISpPKAA1	PDIU	11
5005b00001ISpPKAA1	PDS	12
5005b00001ISpPKAA1	Network	13
5005b00001ISpPKAA1	PDS	14
5005b00001ItbDKAAZ		1
5005b00001ItbDKAAZ	Network	2
5005b00001ItbDKAAZ	PDS	3
5005b00001ItbDKAAZ	PDS	4
5005b00001ItbDKAAZ	PDS	5
5005b00001ItbDKAAZ	PDS	6
5005b00001ItbDKAAZ	Network	7
5005b00001ItbDKAAZ	PDS	8
5005b00001ItbDKAAZ	Network	9
5005b00001ItbDKAAZ	PDS	10

By using a cross tab I was able to transform data as below.

Max_Order Number

5005b00001ISpPKAA1

Network

PDS

PDIU

PDS

Network

PDS

PDIU

PDS

Network

PDS

5005b00001ItbDKAAZ

Network

PDS

Network

PDS

Network

PDS

5005b00001JxBz9AAF

Network

PDS

Network

PDS

Network

PDS

My question is I need write a condition to show the flow for each ID only when the team in the subsequent field changes.

The number of fields for Each Id is shown by Max Order Number.

Below is the expected Outcome

ID	Max_Order Number	Case Flow
5005b00001ISpPKAA1	14	Network-PDS-PDIU-PDS-Network-PDS-PDIU-PDS-Network
5005b00001ItbDKAAZ	10	Network-PDS-Network-PDS-Network-PDS
5005b00001JxBz9AAF	8	Network-PDS-Network-PDS-Network-PDS

I have uploaded the data in the file. Any help is much appreciated .

Thank you,

Digvijay

Question_Condition.yxmd

Expression

Accepted answers

Sebastiaandb

Hi @reddyd3 ,

I took @binu_acs workflow and altered it (so credits for him, thanks!)

Greetings,

Seb

Question_Conditionv2.yxmd

reddyd3

Hi Sebastiandb,

Can you please attach the alteryx workbook.

Thank you so much for the solution. This helps a lot for my analysis. :-)

Digvijay

All comments

binu_acs

@reddyd3

Question_Condition.yxmd

reddyd3

Hi Binuacs,

Thank you very much for sharing the solution.

You see the condition is that if the same team appear in subsequent rows that value should be skipped until the team changes, so when you see PDS and PDS appearing in the two consequent rows it should not repeat the team value.