Partial keys match

Sat, 22 Aug 2009 02:02:00 GMT

Is it possible to create a partial key where A & '|' & B & '|' would be equal to A & '|' & B & '|' & C or one involving a wildcard. For what its worth, could the first two elements be text and the third be a date or a wildcard date.

Partial keys match

stephencredmond — Mon, 24 Aug 2009 17:16:38 GMT

Hi,

No. You need to have complete keys.

You can though create multiple copies of the keys for different connections. Connect A & B & C for connection to one table and A & C to another.

You might also look at Interval Match where you have ranges of dates that you want to match.

Stephen

topic Partial keys match in QlikView

Partial keys match

Partial keys match