Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have and ODBC connection and a table file from a CSV file loaded into QlikView. Both of these have project names that we pull into QlikView. I want to create an expression that will return values of projects that are in the ODBC connection but not in the CSV file. How would I go about doing this?
Hi Matt,
Create a flag or so from where its being loaded:
Something like:
TableODBC:
Load
*,
0 as [Flag Type] // Type of connection
From [Connection];
TableCSV:
Load
*,
1 as [Flag Type]
From [CSV File];
After that, do a count on each respective flag to check how many are coming from where.
count({<[Flag Type]={0}>}Distinct ProjectName) // Counts the ProjectNames that come from ODBC connection.
count({<[Flag Type]={1}>}Distinct ProjectName) // Counts the ProjectNames that come from CSV connection.
Felipe.