topic Re: Subfield help in QlikView

Subfield help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Issue	Code
Critical	1234,5678,9810

Hi,

The above is a mock-up of how I'm getting data. Several codes are in one column separated with a comma. The question is how do I make 3 rows from the above. Thank you!

Needed Result.

Issue	Code
Critical	1234

Issue	Code
Critical	5678

Issue	Code
Critical	9810

Re: Subfield help

Anonymous — Mon, 08 May 2017 20:40:31 GMT

LOAD Issue,subfield(Code,',')

from...

Re: Subfield help

el_aprendiz111 — Mon, 08 May 2017 21:30:17 GMT

Hi,

LOAD *,
SubField(Code,',',1) AS Code1,
SubField(Code,',',2) AS Code2,
SubField(Code,',',3) AS Code3;
LOAD * Inline
[
Issue |Code
Critical | 1234,5678,9810
](delimiter is '|');

EXIT Script;

Re: Subfield help

Tue, 09 May 2017 03:05:44 GMT

Hi, how are you?

Could you try this?

LOAD

Issue

subfield(Code,',') as Code

From [path]

Re: Subfield help

ahaahaaha — Tue, 09 May 2017 07:07:13 GMT

Hi Joseph,

May be like this

//model your source data

Table1:

LOAD * Inline

[

Issue |Code

Critical | 1234,5678,9810

](delimiter is '|');

NoConcatenate

//convert source data

FinishTable:

LOAD

Issue,

SubField(Code, ',', IterNo())

Resident Table1

While IterNo()<=SubStringCount(Code, ',')+1;

Drop Table Table1;

Result

Regards,

Andrey

Re: Subfield help

Anil_Babu_Samineni — Tue, 09 May 2017 07:13:10 GMT

Are you expecting same with Sub Headers for each Row?? If not simply do with roharoha provided.

Re: Subfield help

Anonymous — Tue, 09 May 2017 13:56:21 GMT

Thank you Everyone!!!