Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

number to text

Hi all,

I have a data in excel    with the column name

Number

1

2

3

4

5

6

so I want to load this in qlik result as

1     --one

2  -- two

3  -- three

-----  like so on..

1 Solution

Accepted Solutions
its_anandrjs

Here you have to do the Mapping Load is best option

MapTab:

Mapping Load * inline

[

Number,NumToText

1,one

2,two

3, three

];

Load *,applymap('MapTab',Number,'None')

Load * inline

[

Number

1

2

3

4

5

6

];

View solution in original post

8 Replies
Kushal_Chawda

tresesco
MVP
MVP

its_anandrjs

Here you have to do the Mapping Load is best option

MapTab:

Mapping Load * inline

[

Number,NumToText

1,one

2,two

3, three

];

Load *,applymap('MapTab',Number,'None')

Load * inline

[

Number

1

2

3

4

5

6

];

soniasweety
Master
Master
Author

thanks all. good example anand

Kushal_Chawda

If you have fixed numbers then you can go with approach suggested by the Anand, but if your numbers are dynamic then you need to go with different approach suggested by me & Tresesco

its_anandrjs

Thanks If you have more numbers like in 1000+ then go with Marcus Suggestion.

Translation from Numbers in Words

soniasweety
Master
Master
Author

its fixed numbers I have only 15 in my excel.   thanks for the explanation

soniasweety
Master
Master
Author

Okay anand thanks.