Combining 3 columns and get unique values out of it

Question

Hi, I am trying to combine 3 attributes named S1,S2,S3 which has the person number and then need to find unique values out of it. Can help please help me understand how can we do this ? For ex: if there is below values under column: S1 S2 S3 A1 A2 A3 A1 A4 A1 so, I need to have unique values from these 3 columns i.e. A1, A2. A3, A4. This is what I'm trying to achieve. Any suggestions on this please. Thanks in advance.

Ruvina Khan · Answer

Hi Gianni Ceresa,

Thank you for the help. I missed mentioning it, I wanted to do it in DV Workbook in FDI/FAW.

Is there a way to achieve it?

Gianni Ceresa · Answer

You don't say "where" or "how" you would like to do that: analysis, DV workbook, semantic model/RPD, Publisher?

Keeping it simple, assuming there is a SQL source somewhere there behind, UNION is what you look for.

with t as (
    select 1 a, 1 b from dual 
    union all 
    select 2, 1 from dual 
    union all 
    select 1, 3 from dual
)
select a as unique_values from t
union
select b from t;

# result

UNIQUE_VALUES

1

2

3

You need to join 3 queries for each individual column S1, S2 and S3 with a UNION (and not UNION ALL).

Can't say more on how you can practically implement it without knowing what part of the product you are asking about.

Ruvina Khan · Answer

Hi Philippe Lions-Oracle,

Concatenation will merge these 3 columns. But I want the repeated values to be calculated once even if the value appears in different column/row. For instance: S1: 1, S2: 2, S3: 1, so unique value will be 1 and 2 only, as 1 is repeated twice but I want it to pull once only. so, is there a way to achieve this?