topic Re: Join specific cell as column in QlikView

Join specific cell as column

tamilarasu — Wed, 04 Mar 2015 02:51:13 GMT

Hi,

I want to join a specific cell value as column in a table. Please see the below screenshot for better understanding.

Input data

What I need - Output

Is this possible in load script?

Thanks in advance.

Kind Regards,

Tamil

Re: Join specific cell as column

prma7799 — Wed, 04 Mar 2015 03:48:05 GMT

Hi Nagraj,

Can you post some sample data?

Thanks

Re: Join specific cell as column

tamilarasu — Wed, 04 Mar 2015 04:00:21 GMT

Hi prasahant,

Attached.

Re: Join specific cell as column

prma7799 — Wed, 04 Mar 2015 04:29:09 GMT

PFA

Re: Join specific cell as column

Anonymous — Wed, 04 Mar 2015 04:53:04 GMT

This method is dynamic.

LOAD Sno,

Cust,

Prod,

[Sold Qty],

Price

FROM

[Sample.xlsx]

(ooxml, embedded labels, header is 2 lines, table is Sheet1);

Join

First 1

LOAD

B as Country

FROM

[Sample.xlsx]

(ooxml, no labels, table is Sheet1);

Re: Join specific cell as column

robert_mika — Wed, 04 Mar 2015 05:01:21 GMT

tab1:

LOAD

Sno,

Cust,

Prod,

[Sold Qty],

Price

FROM

Sample.xlsx

(ooxml, embedded labels, header is 2 lines, table is Sheet1);

tab2:

LOAD

B as Country

FROM

Sample.xlsx

(ooxml, explicit labels, table is Sheet1)

WHERE RecNo() =1

Re: Join specific cell as column

tamilarasu — Wed, 04 Mar 2015 05:02:37 GMT

Hi prasahant,

Thanks. But I have around 100 files., so I can't hard code the country name each time.

Re: Join specific cell as column

tamilarasu — Wed, 04 Mar 2015 05:07:57 GMT

Thank you so much All.