Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Lookup functionality

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

2 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

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


Not applicable
Author

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

V

resident

V1;

concatenate

(All)

load

CNTRY_CD as

V

resident

V2;