Sum 2 different nationalities

[#1]

Hello,

For my first message on this forum I would like to ask a question regarding calculation on nationalities.

My observations can have 2 different nationalities stored in two variables (Nat1 and Nat 2)

My question is how can I observe one nationality simultaneously on those 2 variables ?

Example

                    Nat1      Nat2

customer 1:      US     CA

customer 2:      CA     N/A

customer 3:     DE     US

With the list above I need to be able to count 2US , 2 CA and one DE

Is it also possible to only have one selection option in the filter ?

Thanks in advance

[sunny_talwar · Accepted solution]

Create a link table in this case

Table:

LOAD Customer,

          Nat1,

          Nat2

FROM ...;

LinkTable:

LOAD DISTINCT Customer,

     Nat1 as Nat,

     'Nat1' as Flag

Resident Table;

Concatenate (LinkTable)

LOAD DISTINCT Customer

     Nat2 as Nat,

     'Nat2' as Flag

Resident Table;

[#3]

Thanks a lot that's perfect