topic Re: Splitting into rows in QlikView

Splitting into rows

farru_scorpio — Sun, 16 Sep 2018 10:44:47 GMT

Dear Experts,

Is it possible to split a cell value into rows like shown in below tables in qlikview?

Please help.

JaMajka1 — Sun, 16 Sep 2018 11:43:11 GMT

Hello Farrukh,

you have to use subfield() function without third paramter. This leads to creation new rows. Your load scipt then will be like this:

[table]:

noconcatenate

load * inline

["Airline-DM","Class-DM"

A,"1,2,3"

B,4

];

[new_table]:

noconcatenate

load

"Airline-DM",

subfield("Class-DM",',') as new_column

resident table;

drop table table;

Hope it helps,

Maria

farru_scorpio — Sun, 16 Sep 2018 12:01:59 GMT

Dear Maria,

Great! Thanks a lot.

JaMajka1 — Sun, 16 Sep 2018 12:07:54 GMT

You are welcome . Please mark it as correct answer so your question will be flagged as "answered".