In One Database not in the Other

[mparker123]

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?

[felipedl]

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.