topic subfield in QlikView

subfield

vijetas42 — Mon, 30 Jul 2018 18:43:39 GMT

hi all,

I have values in field like,

1234;231;422;

12344;8982;223;

1212;

and i want to separate out values in to different rows so, i have used subfield but, it is creating one more null record for each vale how to remove that

Re: subfield

m_woolf — Mon, 30 Jul 2018 18:47:02 GMT

subfield(left(Yourfield,len(Yourfield)-1),';') as whatever

Re: subfield

MarcoWedel — Mon, 30 Jul 2018 21:32:37 GMT

Hi,

one solution might be:

table1:
LOAD *
Where Len(Trim(value));
LOAD *,
    SubField(field,';') as value
Inline [
    field
    1234;231;422;
    12344;8982;223;
    1212;
];

hope this helps

regards

Marco