Subfield help

[Anonymous]

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

[Anonymous]

LOAD Issue,subfield(Code,',')

from...

[el_aprendiz111]

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;

[#4]

Hi, how are you?

Could you try this?

LOAD

    Issue

    subfield(Code,',') as Code

From [path]

[ahaahaaha]

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

[Anil_Babu_Samineni]

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

[Anonymous]

Thank you Everyone!!!