topic Re: Help need for loading data in QlikView

Help need for loading data

Thu, 13 Dec 2012 00:19:05 GMT

I am loading Table A(PO_Key is combination of 3 fields).

Pl help..

Table A:

AL1,

AL2,

AL3,

AL1 &'-'& AL2 &'-'& AL3 as PO_Key,

Reg,

Date,

Mastr

From Qvd A(qvd)

where Year(Date)>'2007' ;

Table B:

BL1,

BL2,

BL3,

BL1 &'-'& BL2 &'-'& BL3 as PO_Key,

Meg,

str

From Qvd B(qvd) ;

Concatinate

CL1,

CL2,

CL3,

CL1 &'-'& CL2 &'-'& CL3 as PO_Key,

Ver

From Qvd C(qvd);

MayilVahanan — Thu, 13 Dec 2012 01:10:27 GMT

try with exists concept. like

where exists(po_key,po_key);

Thu, 13 Dec 2012 01:11:51 GMT

I tried this.. It is saying PO_Key does not exsist.

This may br PO_Key is combination of 3 fields.

MayilVahanan — Thu, 13 Dec 2012 01:22:00 GMT

try with resident concept and drop the actual table.

load * resident tablename where exists(fieldname,fieldname);

hope it helps.