Resident Load

[mato32188]

Hello,

I just want to load data from previously joined tables by resident load...but table is not created...Has anyone solution?

Thanks

tmp1:

LOAD PrOrderNum as [PrOrderNumBOM],

     ItemCode as Material,

     Qty,

     Price

FROM

..\ProdBOM.qvd

(qvd)

where PrOrderNum>=9000000 and WildMatch(CtrlType, '*Pur*', '*isual');  

left Join(tmp1)

prodorder:

LOAD PrOrderNum as [PrOrderNumBOM],

     UpPrOrderNum as [UpPrOrderNum(BOM)]

FROM

..\ProdOrder.qvd

(qvd)

where PrOrderNum>=9000000;

final:

LOAD

[PrOrderNumBOM],

Material,

Qty,

Price,

[UpPrOrderNum(BOM)]

Resident tmp1

;

DROP Table tmp1;

[Anonymous]

Do the preceding load like this and confirm.

load [PrOrderNumBOM],Material,Qty,Price,[UpPrOrderNum(BOM)];

final:

LOAD

[PrOrderNumBOM],

Material,

Qty,

Price,

[UpPrOrderNum(BOM)]

Resident tmp1

;

DROP Table tmp1;

[marcus_sommer]

You need a noncatenate load by your final-table the qv concatenated tables with the same columns automatically.

- Marcus

[Anonymous]

I suppose you Need to add noconcatenate as the fields have the same name

by Default Qv concatenates the data

final:

noconcatenate load ..

[PrashantSangle · Accepted solution]

Hi,

there is two way to acheive it.

1) use Noconcatenate before Creating Final Table

like,

tmp1:

LOAD PrOrderNum as [PrOrderNumBOM],

     ItemCode as Material,

     Qty,

     Price

FROM

..\ProdBOM.qvd

(qvd)

where PrOrderNum>=9000000 and WildMatch(CtrlType, '*Pur*', '*isual');  

left Join(tmp1)

//prodorder:

LOAD PrOrderNum as [PrOrderNumBOM],

     UpPrOrderNum as [UpPrOrderNum(BOM)]

FROM

..\ProdOrder.qvd

(qvd)

where PrOrderNum>=9000000;

noconcatenate

final:

LOAD

[PrOrderNumBOM],

Material,

Qty,

Price,

[UpPrOrderNum(BOM)]

Resident tmp1

;

DROP Table tmp1;

2) Rename one field in Final table

Like,

tmp1:

LOAD PrOrderNum as [PrOrderNumBOM],

     ItemCode as Material,

     Qty,

     Price

FROM

..\ProdBOM.qvd

(qvd)

where PrOrderNum>=9000000 and WildMatch(CtrlType, '*Pur*', '*isual');  

left Join(tmp1)

//prodorder:

LOAD PrOrderNum as [PrOrderNumBOM],

     UpPrOrderNum as [UpPrOrderNum(BOM)]

FROM

..\ProdOrder.qvd

(qvd)

where PrOrderNum>=9000000;

noconcatenate

final:

LOAD

[PrOrderNumBOM] as New_PrOrderNumBOM,

Material,

Qty,

Price,

[UpPrOrderNum(BOM)]

Resident tmp1

;

DROP Table tmp1;

Regards

[#6]

tmp1:

LOAD PrOrderNum as [PrOrderNumBOM],

     ItemCode as Material,

     Qty,

     Price

FROM

..\ProdBOM.qvd

(qvd)

where PrOrderNum>=9000000 and WildMatch(CtrlType, '*Pur*', '*isual'); 

left Join(tmp1)

prodorder:

LOAD PrOrderNum as [PrOrderNumBOM],

     UpPrOrderNum as [UpPrOrderNum(BOM)]

FROM

..\ProdOrder.qvd

(qvd)

where PrOrderNum>=9000000;

Noconcatenate

final:

LOAD

[PrOrderNumBOM],

Material,

Qty,

Price,

[UpPrOrderNum(BOM)]

Resident tmp1

;

DROP Table tmp1;

or rename the fields