Hi Team Can i seek ur help in conditional sorting. Data is grouped based on Area /Category. Sorting of column Comment 1 should happen basis the column chk.(i.e if chk is summation negative for a area & category then comment 1 should be sorted with decrease; if chk is summation positive for a area & category then comment 1 should be sorted with increase) Appreciate your time Thanks. Actual Data: Area CategoryChkComment 1BostonCEuSummation Negative BostonCEuSummation NegativeDecrease in SalesBostonCEuSummation NegativeIncrease in SalesBostonEuSummation Positive DallasSSummation Positive DallasSCSummation Negative DallasSCSummation NegativeDecrease in SalesDallasSCSummation NegativeIncrease in SalesNewyorkCRuRSummation Positive CaliforniaCSummation Negative SingaporeCSummation Positive CanadaCSuSummation Positive CanadaSuSummation Positive WhalesCSummation Positive WhalesCSummation PositiveDecrease in SalesWhalesCSummation PositiveIncrease in Sales Expected result: Area CategoryChkComment 1BostonCEuSummation NegativeDecrease in SalesBostonCEuSummation NegativeIncrease in SalesBostonCEuSummation Negative BostonEuSummation Positive DallasSSummation Positive DallasSCSummation NegativeDecrease in SalesDallasSCSummation NegativeIncrease in SalesDallasSCSummation Negative NewyorkCRuRSummation Positive CaliforniaCSummation Negative SingaporeCSummation Positive CanadaCSuSummation Positive CanadaSuSummation Positive WhalesCSummation PositiveIncrease in SalesWhalesCSummation PositiveDecrease in SalesWhalesCSummation Positive

Hi, @SrinivasanSugumaran What is your real data of the field [Comment 1] ? Number or String ? IIF([Chk] = 'Summation Negative', IIF(IsEmpty([Comment 1]), 0, [Tile_SequenceNum]) * -1, IIF(IsEmpty([Comment 1]), [Tile_SequenceNum] + [Max_Tile], [Tile_SequenceNum])) AreaCategoryChkComment 1BostonCEuSummation NegativeIncrease in SalesBostonCEuSummation NegativeDecrease in SalesBostonCEuSummation Negative BostonEuSummation Positive DallasSSummation Positive DallasSCSummation NegativeIncrease in SalesDallasSCSummation NegativeDecrease in SalesDallasSCSummation Negative NewyorkCRuRSummation Positive CaliforniaCSummation Negative SingaporeCSummation Positive CanadaCSuSummation Positive CanadaSuSummation Positive WhalesCSummation PositiveDecrease in SalesWhalesCSummation PositiveIncrease in SalesWhalesCSummation Positive

Conditional sorting of a column based on another column -Alteryx Designer

SrinivasanSugumaran

Hi Team

Can i seek ur help in conditional sorting.

Data is grouped based on Area /Category.

Sorting of column Comment 1 should happen basis the column chk.(i.e if chk is summation negative for a area & category then comment 1 should be sorted with decrease; if chk is summation positive for a area & category then comment 1 should be sorted with increase)

Appreciate your time

Thanks.

Actual Data:

Area	Category	Chk	Comment 1
Boston	CEu	Summation Negative
Boston	CEu	Summation Negative	Decrease in Sales
Boston	CEu	Summation Negative	Increase in Sales
Boston	Eu	Summation Positive
Dallas	S	Summation Positive
Dallas	SC	Summation Negative
Dallas	SC	Summation Negative	Decrease in Sales
Dallas	SC	Summation Negative	Increase in Sales
Newyork	CRuR	Summation Positive
California	C	Summation Negative
Singapore	C	Summation Positive
Canada	CSu	Summation Positive
Canada	Su	Summation Positive
Whales	C	Summation Positive
Whales	C	Summation Positive	Decrease in Sales
Whales	C	Summation Positive	Increase in Sales

Expected result:

Area	Category	Chk	Comment 1
Boston	CEu	Summation Negative	Decrease in Sales
Boston	CEu	Summation Negative	Increase in Sales
Boston	CEu	Summation Negative
Boston	Eu	Summation Positive
Dallas	S	Summation Positive
Dallas	SC	Summation Negative	Decrease in Sales
Dallas	SC	Summation Negative	Increase in Sales
Dallas	SC	Summation Negative
Newyork	CRuR	Summation Positive
California	C	Summation Negative
Singapore	C	Summation Positive
Canada	CSu	Summation Positive
Canada	Su	Summation Positive
Whales	C	Summation Positive	Increase in Sales
Whales	C	Summation Positive	Decrease in Sales
Whales	C	Summation Positive

Workflow

Accepted answers

Qiu

@SrinivasanSugumaran
I made a few assumptions

1. By "summation", meaning that there is case that Positive and Negative are mixed in one Area /Category, and the majority will prevail.

2. The blank row always gos to bottom.

1128-SrinivasanSugumaran.yxmd

flying008

Hi, @SrinivasanSugumaran

What is your real data of the field [Comment 1] ? Number or String ?

录制_2024_11_28_16_39_49_840.gif

录制_2024_11_28_16_40_47_895.gif

IIF([Chk] = 'Summation Negative',  IIF(IsEmpty([Comment 1]), 0, [Tile_SequenceNum]) * -1, IIF(IsEmpty([Comment 1]), [Tile_SequenceNum] + [Max_Tile], [Tile_SequenceNum]))

Area	Category	Chk	Comment 1
Boston	CEu	Summation Negative	Increase in Sales
Boston	CEu	Summation Negative	Decrease in Sales
Boston	CEu	Summation Negative
Boston	Eu	Summation Positive
Dallas	S	Summation Positive
Dallas	SC	Summation Negative	Increase in Sales
Dallas	SC	Summation Negative	Decrease in Sales
Dallas	SC	Summation Negative
Newyork	CRuR	Summation Positive
California	C	Summation Negative
Singapore	C	Summation Positive
Canada	CSu	Summation Positive
Canada	Su	Summation Positive
Whales	C	Summation Positive	Decrease in Sales
Whales	C	Summation Positive	Increase in Sales
Whales	C	Summation Positive

All comments

flying008

Hi, @SrinivasanSugumaran

What's your logic for the blank cell of filed [Comment 1] ?

录制_2024_11_28_14_38_44_130.gif

Area	Category	Chk	Comment 1	Tile_Num	Tile_SequenceNum	Alpha
Boston	CEu	Summation Negative	Increase in Sales	1	-3	A3
Boston	CEu	Summation Negative	Decrease in Sales	1	-2	A2
Boston	CEu	Summation Negative		1	-1	A1
Boston	Eu	Summation Positive		2	1	A1
Dallas	S	Summation Positive		3	1	A1
Dallas	SC	Summation Negative	Increase in Sales	4	-3	A3
Dallas	SC	Summation Negative	Decrease in Sales	4	-2	A2
Dallas	SC	Summation Negative		4	-1	A1
Newyork	CRuR	Summation Positive		5	1	A1
California	C	Summation Negative		6	-1	A1
Singapore	C	Summation Positive		7	1	A1
Canada	CSu	Summation Positive		8	1	A1
Canada	Su	Summation Positive		9	1	A1
Whales	C	Summation Positive		10	1	A1
Whales	C	Summation Positive	Decrease in Sales	10	2	A2
Whales	C	Summation Positive	Increase in Sales	10	3	A3

SrinivasanSugumaran

Thanks for the reply. Blank should always be at bottom. Can u pls attach the workflow too

Qiu

@SrinivasanSugumaran
I made a few assumptions

1. By "summation", meaning that there is case that Positive and Negative are mixed in one Area /Category, and the majority will prevail.

2. The blank row always gos to bottom.

1128-SrinivasanSugumaran.yxmd

SrinivasanSugumaran

@flying008 - Thanks for the reply. Blank should always be at bottom. Can u pls attach the workflow too

flying008

Hi, @SrinivasanSugumaran

What is your real data of the field [Comment 1] ? Number or String ?

录制_2024_11_28_16_39_49_840.gif

录制_2024_11_28_16_40_47_895.gif

IIF([Chk] = 'Summation Negative',  IIF(IsEmpty([Comment 1]), 0, [Tile_SequenceNum]) * -1, IIF(IsEmpty([Comment 1]), [Tile_SequenceNum] + [Max_Tile], [Tile_SequenceNum]))

Area	Category	Chk	Comment 1
Boston	CEu	Summation Negative	Increase in Sales
Boston	CEu	Summation Negative	Decrease in Sales
Boston	CEu	Summation Negative
Boston	Eu	Summation Positive
Dallas	S	Summation Positive
Dallas	SC	Summation Negative	Increase in Sales
Dallas	SC	Summation Negative	Decrease in Sales
Dallas	SC	Summation Negative
Newyork	CRuR	Summation Positive
California	C	Summation Negative
Singapore	C	Summation Positive
Canada	CSu	Summation Positive
Canada	Su	Summation Positive
Whales	C	Summation Positive	Decrease in Sales
Whales	C	Summation Positive	Increase in Sales
Whales	C	Summation Positive

SrinivasanSugumaran

Thanks @Qiu ,@flying008

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335