Combine the two columns into single column without loosing the data

[matildecapo]

Hi to everyone,

I have a table like that:

column1   column2  column3   column4

AA, BB       123              456             789

AB,CC       234               678              123

AA              567              786                 890

And i want a table like this:

column1   column2  column3   column4

AA               123              456             789

BB              123              456             789

AB              234               678              123

CC             234               678              123

AA              567              786               890

any advice?

[Raja2022]

Please give a try with the below code and it should work and hope this helps:

Load distinct
SubField(column1,' ,') as column1,
column2,
column3,
column4
;

Load * inline [
column1|column2|column3|column4
AA, BB|123|456|789
AB,CC|234|678|123
AA|567|786|890
] (delimiter is '|');

[vinieme12]

there's no need of a preceding load, this can be done in a single pass

TableName:

Load subfield(column1,',') as column1,column2,column3,column4 inline [
column1|column2|column3|column4
AA, BB|123|456|789
AB,CC|234|678|123
AA|567|786|890
] (delimiter is '|');

[matildecapo]

thanks for your help,

this will work if I have few data. However, my database have more than 30 columns and 50000 rows.

What should I do in that case?

[vinieme12]

You can try the solution first to gauge the performance

[Raja2022]

I did used it on large data sets with out any issues,  So give a try...