topic Re: Divide file in two different script in QlikView

Divide file in two different script

Mon, 12 Nov 2012 12:02:00 GMT

Can I load single excel file in two script?

i.e.

SALE is the excel file and I want to load as below

In hidden script

Field1

Field2

Field3

In normal script

Field4

Field5

Field6

But need all Field shold be available in SALE table...

Re: Divide file in two different script

Mon, 12 Nov 2012 12:23:26 GMT

Hi,

You can do this by splitting the table on a Key field. For example, in the Hidden script you can have:

Sales:

Load

* inline

[
Value
101
102
103
];

In the normal script, you can write:

Load

* inline

[
Value
106
104
105
];

For a little more detail,

In the hidden script, you can have Field1

SalesXY:

Load * inline

[

Key,Field1

101,A

102,B

103,C

];

In the hidden script, you can have Field2

Upon reload, the SalesXY table will should all the fields.

Please find attachment (password for hidden script is 123456). Is that what you are looking for ?

-Khaled.

Re: Divide file in two different script

Mon, 12 Nov 2012 12:56:57 GMT

Dear Khaled,

Thanks for your response.

My mistake, haven't explain query in proper way.

Please find attached excel file.

What I want...

In hidden script

load Invoice No and Invoice Date only

In Normal script

Load Part NO, QTY, Price (INV)

Basically want to hide Inovice No and Invoice Date...!!!

Final outcome should be like below.

Invoice No	Invoice Date	Part NO	QTY	Price (INV)	Inv Total
Inv 001	25/09/12	Part 001	20	7.00	140.00
Inv 001	25/09/12	Part 002	4	50.92	203.68
Inv 001	25/09/12	Part 003	7	63.98	447.86
Inv 002	30/09/12	Part 004	1	195.16	195.16
Inv 002	30/09/12	Part 005	5	252.14	1260.70
Inv 003	01/10/12	Part 006	12	84.31	1011.72
Inv 003	01/10/12	Part 007	2	72.65	145.30
Inv 003	01/10/12	Part 008	6	104.01	624.06
Inv 003	01/10/12	Part 009	35	15.36	537.60
Inv 003	01/10/12	Part 010	3	28.85	86.55
Inv 003	01/10/12	Part 011	16	10.29	164.64
Inv 004	05/10/12	Part 012	66	10.12	667.92
Inv 004	05/10/12	Part 013	75	12.00	900.00
Inv 005	20/10/12	Part 014	3	361.51	1084.53

Re: Divide file in two different script

Mon, 12 Nov 2012 13:32:18 GMT

Hi,

Please find the attachment. Use the same password.

Hope that helps.

- Khaled.

Re: Divide file in two different script

Mon, 12 Nov 2012 13:48:25 GMT

It's working... Thanks for your help.