topic Re: Resident Load in QlikView

Resident Load

mato32188 — Fri, 22 Aug 2014 10:34:58 GMT

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;

Re: Resident Load

Anonymous — Fri, 22 Aug 2014 10:37:38 GMT

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;

Re: Resident Load

marcus_sommer — Fri, 22 Aug 2014 10:38:00 GMT

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

- Marcus

Re: Resident Load

Anonymous — Fri, 22 Aug 2014 10:38:37 GMT

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

by Default Qv concatenates the data

final:

noconcatenate load ..

Re: Resident Load

PrashantSangle — Fri, 22 Aug 2014 10:43:37 GMT

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

Re: Resident Load

Fri, 22 Aug 2014 11:01:08 GMT

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