One field value associated with more than one values from another field

ShellyG — Mon, 10 May 2021 14:58:35 GMT

Hi Community,

I need help with an expression example for the following situation.

I have a simple dataset where I have a field, which contains group names - Group1, Group2, etc... I also have a field containing group codes - A, B, C and D.

Each of these groups can have either one of the codes or multiple codes. For example:

Group1 - A
Group2 - A, B, C
Group3 - C, D

I want to create an additional field in my script, which will identify the groups that have multiple codes as 'Multiple' and the groups that have only one code as 'One'.

Can you please help me with a sample expression of how to achieve that?

Best Regards,

Shelly

Re: One field value associated with more than one values from another field

JuanGerardo — Mon, 10 May 2021 15:23:56 GMT

Hi @ShellyG , you can add that field in the following way:

...

Left Join(GroupNameTable)

Load

GroupName,

If(Count(Distinct GroupCode) > 1, 'Multiple', 'One') AS MultipleField

Resident GroupCodeTable

Group By GroupName;

...

topic Re: One field value associated with more than one values from another field in App Development

One field value associated with more than one values from another field

Re: One field value associated with more than one values from another field