topic Re: Lookup in QlikView

Lookup

vardhancse — Thu, 24 Jul 2014 15:33:01 GMT

Have a requirement is that:

need to fill field_2 data based on field_1.

using lookup function.

Re: Lookup

MK_QSL — Thu, 24 Jul 2014 15:34:53 GMT

Please elaborate little more and if possible, provide some sample data.

Re: Lookup

vardhancse — Thu, 24 Jul 2014 15:41:23 GMT

Have 2 tables:

table_1:

Field_2

Field_3

table_2:

Field_1

Field_2

Field_3

in table_2 if field_3 value is blank then based on Field_2 from table_2 need to lookup in Field_2 from table_1

Re: Lookup

Thu, 24 Jul 2014 15:47:04 GMT

Hi,

Use an IF and ApplyMap, something like this:

table_1:

Mapping

Load

Field_2

Field_3

from table_1.qvd;

table_2:

Load

Field_1

Field_2

If( Len(Trim(Field_3))=0, Applymap('table_1',Field_2) as Field_3

From table_2.qvd;

Best regards.

Re: Re: Lookup

fkeuroglian — Thu, 24 Jul 2014 15:51:12 GMT

See this article

there is a part explain look up function

good luck

Fernando

Re: Lookup

alexandros17 — Thu, 24 Jul 2014 15:53:44 GMT

Here is my example

AA:

LOAD * Inline [

Nome, Eta

Ale, 49

Ange, 47

tato, 10

Dada, 12

];

BB:

LOAD * Inline [

Eta, Fascia

10, Bimbo

12, young

47, Adult

49, Old

];

CC:

NoConcatenate

LOAD lookup('Fascia', 'Eta', Eta, 'BB') as xxx, * resident AA;

DROP Tables AA, BB;

Re: Lookup

MK_QSL — Thu, 24 Jul 2014 15:53:47 GMT

T1:

Load * Inline

[

Field2, Field3

A, 100

B, 120

C, 200

D, 180

];

T2:

Load

Field1,

Field2,

IF(IsNull(Field3) or LEN(TRIM(Field3))=0,Lookup('Field3','Field2',Field2,'T1'),Field3) as Field3

Inline

[

Field1, Field2, Field3

F1, A, 1200

F2, B, 1400

F3, C,

F4, D,

F5, A,

];

Drop Table T1;