unique value

[santharubban]

Hi ALL,

We are facing some issues in our app, we need to pull distinct code for an Encounter key.

  Each Diag code is have 2 different codes,

Diag code 02  is having  ‘8052’ ,the same Diag is
present in the Diag _code_03. This Diag_code should consider only once
not twice because is we are getting count as 2.

pls reffere attachement

[sebastiandperei]

Sorry, but It's very confuse....

Could you send a reduced copy of qvw? and a table with the results you need.

Thanks!

[santharubban]

i need to show diad code only once when its repeated.

[ashfaq_haseeb]

Hi,

Use pivot table and add dial code to dimension

Regards

ASHFAQ

[santharubban]

no i can use pivot because after taking distinct disg code i need to compare with other table and check the matching codes.Then i need to count the match and outage counts.