topic Compare field.table1 with field RANGE in table2 in QlikView

Compare field.table1 with field RANGE in table2

Anonymous — Mon, 09 Nov 2015 23:47:20 GMT

Compare field.table1 with field RANGE in table2 in load script

example something like below but obviously the below doesn't work.

Bring field only when Table1 .FieldX exist in Table2.Field Y

if(Exists(Table2.FieldY,Table1.FieldX)=0,'Does not exist'),

jonathandienst — Tue, 10 Nov 2015 05:57:57 GMT

Exists() only works in script - it is not available in the front end expressions. Use the unqualified field names:

If(Exists(FieldY, FieldX) = 0, 'Does not exist') As [XYExist],

jyothish8807 — Tue, 10 Nov 2015 06:02:34 GMT

Hi Chantelle,

First bring both the fields in to same table using joins, then simply create a field in script.

load

if(field1=field2,field1) as New_field

from <>

Regards