Cross Tab data transformation

Question

Hi Community,

I want to Pivot the data like below please help me getting the desired results, i tried using Cross Tab but unable get the results.

I am also getting the below aggregating options which i am not sure why not working as required

Concatenate

First

Last

Input:

CategoriesAccountsH145B125H6621D112B5400F5440D1223H221

Output:

HBDF1451251125440662154001223 221

JenilShah · Answer

Nice idea acotta17

acotta17 · Answer

Hi @Rajat_Rehria,

You will get your desired output by using the two tools mentioned in the steps below:

1. Use the Tile Tool and select Unique value in the method drop-down while selecting the first column as unique value.

2. Use the Cross-tab Tool and select the Tile_SequenceNum in the Group by while selecting the first column as headers and second column as values.

(Optional: You can use the Sort Tool on the Tile_SequenceNum column and use the select tool to then deselect the column from the output)

[Screenshot for the two steps and output attached below]

Hope this helps :)

Output:

apathetichell · Answer

tile tool - unique value - categories.

use tile sequence number as a primary key in your cross tab. use concatenate.