Splitting Row using QlikView Script

[lawrance]

Hi All,

Please help me to split the rows by using QlikView Script.

For Example,

Source Data:

Date	Name	Company	Location
02/02/2018	ABC	HBK-New	XXXX
03/02/2018	BCA	Intern-Corp	YYYY

Expected Output:

Date	Name	Company	Location
02/02/2018	ABC	HBK	XXXX
02/02/2018	ABC	New	XXXX
03/02/2018	BCA	Intern	YYYY
03/02/2018	BCA	Corp

Thanks,

Lawrance A

[jhoef-pv]

Hi,

Table1:

load

Date,

Name,

subfield(Company,'-',1) as Company,

Location

from SourceData.qvd(qvd);

Concatenate (Table1)

load

Date,

Name,

subfield(Company,'-',2) as Company,

Location

from SourceData.qvd(qvd);

[vishsaggi]

Why dont you just use this?

LOAD Date,

     Name,

     Subfield(Company, '-') AS Company,

     Location

FROM

[https://community.qlik.com/thread/291942]

(html, utf8, embedded labels, table is @1);

[lawrance]

Thanks for your response.

-Lawrance A

[shilpan]

LOAD
Date,
Name,
subfield(Company, '-',1) as Company,
Location
FROM

(ooxml, embedded labels, table is Sheet1);


LOAD
Date,
Name,
subfield(Company, '-',2) as Company,
Location
FROM

(ooxml, embedded labels, table is Sheet1);