topic Re: loading certain fields from an existing table in QlikView

loading certain fields from an existing table

Wed, 02 Jul 2014 13:59:59 GMT

We have a consolidated model that pulls info from different QVD's . Here is a script extract of the script

LOAD DISTINCT *
FROM
[..\QVD\Jhb - ELSDAT\*.qvd]
(qvd);

Within these QVD there are many tables , however i only want to bring in is a table called "Transactions". In this table it contains many fields but i only want three fields, which are

Sales Quantity
MonthIndex
Item Code

I am struggling to get the above right. Here is my scripting below.

LOAD

[Sales Qty],
[MonthIndex],
[Item Code FM]
Resident Transactions;
DROP TABLE Transactions;
FROM
[..\QVD\Jhb - ELLDAT\*.qvd]

(qvd);

Wre am i going wrong? After "DROP TABLE Transactions" everything is underlined in red.

Thank you

kind regards

Nayan

Re: loading certain fields from an existing table

fernando_tonial — Wed, 02 Jul 2014 14:08:57 GMT

Hi, ,

Try this.

New_Transactions:
LOAD
[Sales Qty],
[MonthIndex],
[Item Code FM]
Resident Transactions;
DROP TABLE Transactions;

Best Regards.

Tonial.

Re: loading certain fields from an existing table

Wed, 02 Jul 2014 14:25:16 GMT

Hi Fernando

Thank you for your reply. Do i add your script after the original scripting that i already have. So should the script be as follows:

LOAD DISTINCT *

FROM

[..\QVD\Jhb - ELSDAT\*.qvd]

(qvd);

New_Transactions:

LOAD

[Sales Qty],

[MonthIndex],

[Item Code FM],

Resident Transactions;

DROP TABLE Transactions;

Re: Re: loading certain fields from an existing table

fernando_tonial — Wed, 02 Jul 2014 14:30:37 GMT

Yes, you can try another way.

LOAD DISTINCT
[Sales Qty],
[MonthIndex],
[Item Code FM]
FROM
[..\QVD\Jhb - ELSDAT\Transactions.qvd]
(qvd);

Best Regards.

Tonial.

Re: loading certain fields from an existing table

Wed, 02 Jul 2014 14:34:31 GMT

Try This

NewTransaction:

noconcatenate LOAD

[Sales Qty],

[MonthIndex],

[Item Code FM]

Resident Transactions;

Drop Table Transactions;

Re: loading certain fields from an existing table

Wed, 02 Jul 2014 14:34:43 GMT

Thank you . I will try it out and let you know .

kind regards

Nayan