Dual function

[arvind1494]

Dual function

Hi All,

Can some one Tell me where can i use Dual function in Scrip

Give me some Example script

[kundan_sharma1 · Accepted solution]

Dual() combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes

Syntax:

Dual(text, number)

Load dual ( NameDay,NumDay ) as DayOfWeek inline

[ NameDay,NumDay

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6 ];

The field DayOfWeek

can be used in a chart, as a dimension, for example.In a table with the week days are automatically sorted into their correct number sequence, instead of alphabetical order.

[abhijith862]

Refer the Link for the same:

How to use- Dual()

[d_ankusha]

The Dual function is used to keep values in order.

For example:

Load Dual(day,number) Inline[

day,number

monday,1

tuesday,4

wednesday,2

];

OUTPUT:

monday

wednesday

tuesday

here you can see that the days are arranged in sorted order based on the number field.