topic Re: Subfield function to get output in QlikView

Subfield function to get output

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

Hello Team ,

How can I use Subfiled to get below output:

String	Column1	Column2	Column3
Rohit\|Jalon\|RJ3438; Ramesh\|Roy\|RR65149	RJ3438	RR65149
Rohit\|Jalon\|RJ3438	RJ3438
Rohit\|Jalon\|RJ3438; Ramesh\|Roy\|RR65149; Rakesh\|Singh\|SS54582	RJ3438	RR65149	SS54582

Thanks in advance

sunny_talwar — Thu, 21 Jun 2018 13:10:17 GMT

May be this

Table:

LOAD *,

Trim(SubField(Trim(SubField(String, ';', 1)), '|', -1)) as Column1,

Trim(SubField(Trim(SubField(String, ';', 2)), '|', -1)) as Column2,

Trim(SubField(Trim(SubField(String, ';', 3)), '|', -1)) as Column3;

LOAD * INLINE [

String

Rohit|Jalon|RJ3438; Ramesh|Roy|RR65149

Rohit|Jalon|RJ3438

];

YoussefBelloum — Thu, 21 Jun 2018 13:44:41 GMT

Hi,

here is another way to do it:

Table:

LOAD *,

TextBetween(String,'|',';',2) as Column1,

TextBetween(String,'|',';',4) as Column2,

TextBetween(String,'|','',6) as Column3;

LOAD * INLINE [

String

Rohit|Jalon|RJ3438; Ramesh|Roy|RR65149

Rohit|Jalon|RJ3438

];