loading certain fields from an existing table

[#1]

Hi

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

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

[fernando_tonial]

Hi, ,

Try this.

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

Best Regards.

Tonial.

[#3]

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;

[fernando_tonial · Accepted solution]

Yes, you can try another way.

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

Best Regards.

Tonial.

[#5]

Try This

NewTransaction:

noconcatenate LOAD

               [Sales Qty],

               [MonthIndex],

               [Item Code FM]

Resident Transactions;

Drop Table Transactions;

[#6]

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

kind regards

Nayan