Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Specialist

# Dual function

Hi All,

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

Give me some Example script

1 Solution

Accepted Solutions
Contributor III

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.

3 Replies
Contributor III

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.

Contributor III

Refer the Link for the same:

How to use- Dual()

Creator II

The Dual function is used to keep values in order.

For example:

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.