Vlookup(Comparison of true or false) in Qlikview.

[Srinivas]

Dear all,

I Have column A  and column B here i want comparison of both columns like vlookup TRUE or FALSE.

If column B value exist in Column A then TRUE otherwise FALSE. 

Please Find attached document.

Thanks & Regards

Munna

[JonnyPoole]

This example, establishes the boolean through a set of transformations in the load script. Hope it helps.

[danieloberbilli]

maybe like this:

[Srinivas]

Thanks Daniel,

Here i forget one thing right now this two columns coming from one excel.But my requirement is different table (Different excels) So that how we can merge and solve issue.

Could you please suggest on this.

Product_CD is one table and Local_CD is another table

Advance Thanks

munna

[danieloberbilli · Accepted solution]

This is actually what I did already in the example: although both come from the same excel source, I loaded both fields in separate tables (see below): so just Load from source_a  and load from source_b in the following way.

Product:

LOAD

Product_CD,

Product_CD as Key

Resident Source;

Local:

LOAD

LOCAL_CD,

LOCAL_CD as Key

Resident Source;

[danieloberbilli]

e.g.

LOAD Product_CD,

Product_CD as Key

FROM

Test\Product_CD.xls

(biff, embedded labels, table is [Sheet1$]);

LOAD LOCAL_CD,

LOCAL_CD as Key

FROM

Test\LOCAL_CD.xls

(biff, embedded labels, table is [Sheet1$]);

[Srinivas]

Thanks Daniel.