Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

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

Tags (3)
1 Solution

Accepted Solutions

Re: number to text

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

];

8 Replies

Re: number to text

MVP
MVP

Re: number to text

Re: number to text

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
Valued Contributor III

Re: number to text

thanks all. good example anand

Re: number to text

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

Re: number to text

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

Translation from Numbers in Words

soniasweety
Valued Contributor III

Re: number to text

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

soniasweety
Valued Contributor III

Re: number to text

Okay anand thanks.