Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.