We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

General Discussions

Discuss any topics that are not product-specific here.

Split data as separate tables

SahadhKuruniyan
7 - Meteor

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
17 - Castor

@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
19 - Altair
19 - Altair

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

0503-SahadhKuruniyan.png

SahadhKuruniyan
7 - Meteor

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
7 - Meteor

Thanks mate!

 

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

SahadhKuruniyan
7 - Meteor

Hi @Luke_C 

 

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

SahadhKuruniyan
7 - Meteor

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