topic Re: Sum 2 different nationalities in App Development

Sum 2 different nationalities

Mon, 08 May 2017 08:46:51 GMT

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 — Mon, 08 May 2017 09:33:16 GMT

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;

Mon, 12 Jun 2017 08:38:24 GMT

Thanks a lot that's perfect