Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Divide file in two different script

Can I load single excel file in two script?

  1. 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...

1 Solution

Accepted Solutions
Not applicable

Re: Divide file in two different script

Hi,

Please find the attachment. Use the same password.

Hope that helps.

- Khaled.

4 Replies
Not applicable

Re: Divide file in two different script

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.

-Khaled.

Not applicable

Re: Divide file in two different script

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 NoInvoice DatePart NOQTYPrice (INV)Inv Total
Inv 00125/09/12Part 001207.00140.00
Inv 00125/09/12Part 002450.92203.68
Inv 00125/09/12Part 003763.98447.86
Inv 00230/09/12Part 0041195.16195.16
Inv 00230/09/12Part 0055252.141260.70
Inv 00301/10/12Part 0061284.311011.72
Inv 00301/10/12Part 007272.65145.30
Inv 00301/10/12Part 0086104.01624.06
Inv 00301/10/12Part 0093515.36537.60
Inv 00301/10/12Part 010328.8586.55
Inv 00301/10/12Part 0111610.29164.64
Inv 00405/10/12Part 0126610.12667.92
Inv 00405/10/12Part 0137512.00900.00
Inv 00520/10/12Part 0143361.511084.53
Not applicable

Re: Divide file in two different script

Hi,

Please find the attachment. Use the same password.

Hope that helps.

- Khaled.

Not applicable

Re: Divide file in two different script

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

Community Browser