Match Multiple Columns

[QV_User]

Hi there,

I am looking for a solution on the below, I need QV to match COUNTRY and Contract#. However if there's no contract No. there is a generic contract.

I feel this is failing because of the use of multiple countries and f.e. if the COUNTRY is US in combination with the generic contract it shows, however if the COUNTRY is CA it will not.

Can you help me out here?

[rubenmarin]

Hi, can you post a sample that shows your issue.

Maybe you can create a compsite key:

Country &'_'& Contract as IdContract

This creates a field that combines both fields

[QV_User]

Hi,

Have tried that already.

I have no specific example as I have an ODBC connection running in the background.

[rubenmarin]

Hi, I don't need real data, just an example (qvw or text explanation) of your issue and how is managed the generic contract

[rubenmarin]

BTW, If there is no sensitive data you can upload your qvw to take a look of what is happening, having an ODBC doesn't matter, just I can't make reloads but I can see what are you trying to do.