topic Lookup functionality in QlikView

Lookup functionality

Wed, 02 Jun 2010 12:39:22 GMT

I am trying to show an error pane which is very simple in excel or SQL.

I have a SQL table column called country.

I have another excel table with column country_cd that I ahve loaded.

I need to ensure that all the values in column country are valid when compared to column country_cd and display the ones that do not match (errors).

Thanks.

Kiran

Lookup functionality

fernandotoledo — Wed, 02 Jun 2010 12:47:18 GMT

You can make a validation table Joining the tables from excel and sql (don´t forget to rename the fields to use them as a key field) then "resident load" it with the expression

if(isnul(country_cd),'ERROR','OK') as country_cd_error_flag

Lookup functionality

Wed, 02 Jun 2010 13:04:46 GMT

I am sorry that I am not very good with using resident loads and joining with Qlikview - Ive been away from it for too long.

I am trying a resident load as follows but I am getting error messages while loading. Am i following the right path - My 2 comparison columns are export_country and cntry_cd

//First table

V1:

LOAD

Export_country

FROM

FFSHIP..CUSTOMS_BROKERAGE;

//Second table

V2:

LOAD

CNTRY_CD

FROM

(ooxml, embedded labels, table is Sheet1)

;

// All records from both tables

All:

load

Export_country as

resident

V1;

concatenate

(All)

load

CNTRY_CD as

resident

V2;