Suppose I have 2 tables called Table1 and Table2. I need to join them using a composite key containing 4 fields namely A, B, C and D.
Now the data is as follows:
There are rows in the table2 where one of the mapping fields has ‘*’ in it. This means that for that line in the table that field is ignored, the mapping is then done for all fields on a row with a value other than ‘*’ in a field.
This can happen for more than 1 fields for a single record. For example:
TableName
FieldA
FieldB
FieldC
FieldD
Table1
1
2
3
4
Table2
1
*
3
4
Now for the above example, as FieldB has '*' as a value, key joining happens based on 1-3-4.
Similarly, it may so happen that '*' comes as a value for multiple fields.
How can this be implemented in Qlikview dynamically without hard coding '*' values?
