Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
This is the script I'm using....
Hi,
Can you share your script ?
Aurélien
This is the script I'm using....
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 ....
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
No, I need multiple values here. So that I have used Dual function here... Is there any alternate solution for this?
You need multiple values, but you don't need them? I am confused
Thank you for the reply.... But I didn't get what I expected. It has both text value and numeric value.
I need both text and numeric values here..Plz help
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