number to text

[soniasweety]

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..

[Kushal_Chawda]

see this

convert number to text

[tresesco]

Check these:

Translation from Numbers in Words

[its_anandrjs · Accepted solution]

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]

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]

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

[soniasweety]

Okay anand thanks.