I have below (sample) two tables with each loading some date. I'm concacting both tables.
While I concatanate, I would like to flag the values that are not matching through a new field. In below example, ExternalID A001 in TableA is not found in other table. Could I use anything in Qlikview that will help me add a flag (say new value i.e. A001)?
I could then use this flag to identify in qlikview which new values have been added.
**Please be aware - the above approach works for distinct ExternalIDs - if they are not distinct, you will have create a temp table, with distinct ExternalIDs as field with a different name - and then use that in that in the where clause.