Output of Cross Tab tool arranged alphabetically

Question

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:

ValuesABCAmount to be given471Balance582Checks693

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

ValuesABCChecks693Amount to be given471Balance582

Thanks!!!

Polite123 · Answer

Hi @Emmanuel_G,@binu_acs,@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.

Emmanuel_G · Answer

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

binu_acs · Answer

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

Re-arrange_0920.yxmd