How to add one more QVD table into my QV file ?

[paulyeo11]

Hi All

I have below script which is working fine for very long , it work because all QVD table are having same data structure . today i try to add in one more different data structure table , which appear on the last 2 line of the script . basically the last line of the QVD table is exchange rate table . can some one tell me how can i make it working ? i have try noConcatenate also not work. once it work i can bring in many such table.

PRICE:

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

Concatenate

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

//Concatenate

//load * from $(vQVDPath)IBH_RATE_RATE.qvd (qvd);

[jagan · Accepted solution]

Hi Paul,

Instead of concatenating the table why can't you create it as separate table and link this table via common field name.

Rate:

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

Regards,

Jagan.

[paulyeo11]

Thank you vey much Jagan it work now.