How to add a new field name 'No" as LOCAL_PRODUCT into my QVD table ?

[paulyeo11]

Hi All

Below is the script which i load 2 QVD table.

PRICE:

load * from $(vQVDPath)BECKHOFF.qvd (qvd);

Concatenate

load * from $(vQVDPath)HAKKO.qvd (qvd);

My Question now is i want to add a new field name , let said :-

'No" as LOCAL_PRODUCT,

I try using the above line , i got error. any advise ?

Paul

[#2]

Hi Paul

Use single quote 'No' as fieldname

best regards

Chris

[paulyeo11]

Hi Chri

I use below code , it still not work.

'No' as BRAND_PRODUCT

Previous was typing mistake.

Paul

[#4]

You will do it like this.

PRICE:

LOAD *,

     'No' as  BRAND_PRODUCT

FROM $(vQVDPath)BECKHOFF.qvd (qvd);

CONCATENATE

LOAD *

FROM $(vQVDPath)HAKKO.qvd (qvd);

Regards,

Marius

[antoniotiman]

Hi Paul,

try

Load *,

Null() as BRAND_PRODUCT

From $(....) (qvd);

Concatenate

Load

......

[paulyeo11]

Hi All

Thank you for your reply.

I have try both advise still not able to make it work.

I have a table which is working fine. which having 8704 row of rec.

I have 2nd table which having 9 Rec.

Both table are in QVD file.

Now i need to add a new filed to filter first Table rec , i get stuck.

Hope some one can advise.

Paul

[#7]

Hi Paul,

Kindly send us a sample of your QlikView model.

Thanks,
Marius

[paulyeo11]

Hi Mariuis

I have enclosed the QV doc , which have my data model in side.

Paul

[#9]

Do you simply want to display 8704?

If you simply want to display the calculated figure 8704?

[paulyeo11]

Hi Sir

I want to seperate the 2 table by a field name.

Paul