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

[flying008]

Hi, @SrinivasanSugumaran 

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

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 · Accepted solution]

@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.

[SrinivasanSugumaran]

HI  

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

[flying008 · Accepted solution]

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]))

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