Need to get the unique values for a reference field

[Yesh]

Hi Team,

My reference field is visible like this:

IM Argentina Operating Unit

IM Argentina Operating Unit

IM Argentina Operating Unit

IM Argentina Operating Unit

IM BR OU

IM BR OU

.............

But I need the unique Values.

How to achieve this requirement?

Thanks,

Yesh

[Sagar Pagar]

Hi,

have you checked your reference field display value? Is it showing the similar values to IM Argentina Operating Unit or not?

I guess it is reference field which shows these values (concatenate the two or more fields).

Can you share the reference table fields

Thanks,
Sagar Pagar

[Yesh]

Hi @Sagar Pagar ,

Yes, it is similar to IM Argentina Operating Unit.

[Sagar Pagar]

Hi,

You have to use the unique field to display in reference field.

Thank,

Sagar Pagar

[Yesh]

Hi @Sagar Pagar ,

Okay. But I need the Plant Names to be displayed and those should be unique. Is it possible to do?

Thanks,

Yesh

[Sagar Pagar]

Hi,

You have to control it through the Advanced reference qualifier.

For Script Include & Advanced reference qualifier, go thorough this old thread - How to display only unique values from the Reference variable

Thanks,
Sagar Pagar