Output of Cross Tab tool arranged alphabetically

[Polite123]

Hi team,

I am trying to generate Summary sheet with the help of Cross Tab but the data in column Values is getting arranged alphabetically which is not desired.

Output of Cross Tab:

Values	A	B	C
Amount to be given	4	7	1
Balance	5	8	2
Checks	6	9	3

Required Output(For example ...in actual there are many row items):

Values	A	B	C
Checks	6	9	3
Amount to be given	4	7	1
Balance	5	8	2

Thanks!!!

[JamesCharnley]

Hi @Polite123 ,

If I understand correctly, there's a couple of ways you could sort of manually hack this sort. If it's ever sorted in the correct way during the workflow, then you could add a RecordID or some kind of tag afterwards to be sorted on after the crosstab.

If that doesn't work for whatever reason then you could even just add a manual lookup to join on and sort that way. Neither are ideal but if you attach a mock input then I'm sure myself or someone else will be happy to mock up a workflow.

[binuacs]

@Polite123 One way of doing this. Please note this is not dynamic

[Emmanuel_G]

@Polite123 

Can you please share a dummy sample of data before Cross Tab tool to test ?

At first glance, I would say to insert a recordID before the cross tab tool and just after do an ascending sort on RecordID to find the order of the original rows.

[Polite123]

Hi @Emmanuel_G,@binuacs,@JamesCharnley ,

Thanks for all your help.

I solved it by applying record id and then sorting it after cross tab and finally applying join helped me.