Validation Tab

[#1]

Hi,

In one of my application I want to any objects to this tab that will help with validating data\spotting any discrepancies.

For example: For some the services, service group has not yet been mapped.

I want to highlights SERVICE values that do not have a corresponding mapping in Service Group Name.

Any suggestions how can I do this!

[prieper]

With regards to mapping-tables I always prefer to work with OTHERSYMBOL-function with a script like the below:

SET OtherSymbol = +;
MainTable: LOAD * FROM .....;
ServiceName: LEFT KEEP (MainTable) LOAD ServiceID, ServiceName FROM ....;
MissingService: LOAD * INLINE [ ServiceID, ServiceName
 +, #N/A];

Doing so you may select #N/A (or any other text) in order to show all entries, for which there is not Service-Code mapped.

HTH
Peter

[#3]

Hi Peter,

Thanks for your help. I don't know how to implement this but I will try to implement and let you know the outcome if I am able to implement the same.

[#4]

Hi Peter,

Can you please suggest something which I can do it in the QV side instead of doing it in the script side. Please check with that and let me know.

[prieper]

Think that it is preferable to have this as a real dimension in the script, but you may always use a calculated expression, see the attached file

HTH
Peter

[#6]

Hi Peter,

Thanks!

What you have provided was simple and useful. Do let me know if you have any other suggestions.