Dual Function

[Anonymous]

Guys,

Whenever I use dual function in script, I get duplicate values in the list box after loading the data as shown in the below image. Please help me guys....

[Aurelien_Martinez]

Hi,

Can you share your script ?

Aurélien

[Anonymous · Accepted solution]

This is the script I'm using....

[sunny_talwar]

If you don't want multiple values just assign the flags and don't use dual here

If(Condition1, 'Billable',

     If(Condition2, 'Partially Billable', 'Non Billable')) as ....

[Aurelien_Martinez]

It's because you have multiple value for one label.

For example :

LOAD Dual('toto', id) INLINE [
id
1
2
];

This script give duplicate value "toto" because I have two number (1 and 2).

To slove this problem you can remove the dual:

Load

  If(Numbre>7, 'Value',

   If([...]

) as myField

[Anonymous]

No, I need multiple values here. So that I have used Dual function here... Is there any alternate solution for this?

[sunny_talwar]

You need multiple values, but you don't need them? I am confused

[Anonymous]

Thank you for the reply.... But I didn't get what I expected. It has both text value and numeric value.

[Anonymous]

I need both text and numeric values here..Plz help

[Aurelien_Martinez]

You need both in the same field or you can have 2 fields ?

Like one with the number and the other with the label ?

Or you can add the number to the label like

Load

  If(Number>7, 'Value ' & Number,

    If([...]

  ) as myField