topic Re: Splitting Row using QlikView Script in QlikView

Splitting Row using QlikView Script

lawrance — Mon, 19 Feb 2018 16:14:52 GMT

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

Re: Splitting Row using QlikView Script

jhoef-pv — Mon, 19 Feb 2018 16:21:17 GMT

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);

Re: Splitting Row using QlikView Script

vishsaggi — Mon, 19 Feb 2018 16:37:03 GMT

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);

Re: Splitting Row using QlikView Script

lawrance — Mon, 19 Feb 2018 23:13:33 GMT

Thanks for your response.

-Lawrance A

Re: Splitting Row using QlikView Script

shilpan — Tue, 20 Feb 2018 04:19:07 GMT

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);