Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

Split data as separate tables

SahadhKuruniyan
8 - Asteroid

Hello,

I have a data like below and I have to split these as separate column based on data in column 1:

NumberAccount
1A454
1A434
1A545
1A765
2c-155.9
2c-257.4
2c-358.9
2c-460.4
3D-561.9
3D-663.4
3D-967.9
3D-1069.4

Output should look like this:

NumberAccount
1A454
1A434
1A545
1A765

 

NumberAccount
2c-155.9
2c-257.4
2c-358.9
2c-460.4

 

NumberAccount
3D-561.9
3D-663.4
3D-967.9
3D-1069.4

 

If any one could hep me here that would be a biggest help

8 REPLIES 8
binuacs
20 - Arcturus

@SahadhKuruniyan One way of doing this with the help of Tile tool. Select the unique value option and unique column as Number. Later you can filter out the tile output based on the Tile_Num field

 

binuacs_0-1651490583294.png

 

 

Luke_C
17 - Castor

Hi @SahadhKuruniyan 

 

If you're outputting to excel you could put them on different tabs by configuring the output tool to do so. I think it depends on what exactly you're looking for, are you looking to process the data differently in the workflow based on the number value? Or simply output into distinct tables?

Luke_C_0-1651499321611.png

 

 

Qiu
20 - Arcturus
20 - Arcturus

@SahadhKuruniyan 
Since you mentioned that you want to split data as separate tables, which I assume diffirent Excel Sheets.

0503-SahadhKuruniyan.png

SahadhKuruniyan
8 - Asteroid

Thanks for sharing you knowledge.

But the thing here is ,the number of accounts in column 1 will be added or reduced.

For eg, in above example we have 3 accounts 1A,2C and 3D but that will change.

 

Luke_C
17 - Castor

Hi @SahadhKuruniyan 


Can you share exactly what you're looking for? The 3 solutions provided should work regardless of the number of accounts in the first column. 

SahadhKuruniyan
8 - Asteroid

Thanks mate!

 

I want the data you be in a single tab. Is that possible

SahadhKuruniyan
8 - Asteroid

Hi @Luke_C 

 

I want the the data get splitted as tables in a single excel tab

SahadhKuruniyan
8 - Asteroid

Thanks @binuacs ,

 

In this case I don't have to add a tile tool as first coloumn is already a unique id, so I can filter using it

Labels