How to create new table based on first coulmn value

[umarabdulsattar3275]

[JamesCharnley]

@umarabdulsattar3275  the important tool here is the cross-tab, which allows you to turn rows to columns, but to differentiate between groups you'd just need to first make some kind of tag to group on within the cross-tab so it doesn't aggregate, for example the tile or multi-row formula tool

[umarabdulsattar3275]

Can you please share the alteryx file that i can see in more details.

[JamesCharnley]

@umarabdulsattar3275  I've already attached to original workflow to the post! I'll attach another one here with a multi-row instead of a tile since it could be a bit more intuitive.

Let me know if you have more questions

[umarabdulsattar3275]

to my data it not giving proper tile num

at the end its show me like this all record in same cell 

Thnak you.

[ShankerV]

Hi @umarabdulsattar3275 

You need to change the setting in the Tile tool please.

[JamesCharnley · Accepted solution]

@umarabdulsattar3275  I've attached an alternative with the multi-row formula that might be more intuitive. The way I set the tile up if you wanted to use the tiles you would need to change the number of tiles to match how many groups you need. The multi-row shouldn't need to be changed though, you'll just need to group by that new created field in the cross-tab

[ShankerV · Accepted solution]

Hi @umarabdulsattar3275 

This will help!!!!

[umarabdulsattar3275]

Thank you so much it working now. Thanks a lots💓