Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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_CDFROM
;
// All records from both tables
All:
load
Export_country asV
resident
V1;
concatenate
(All)
load
CNTRY_CD asV
resident
V2;