I have a data in excel with the column name
so I want to load this in qlik result as
2 -- two
3 -- three
----- like so on..
convert number to text
Translation from Numbers in Words
how to convert number into words
Here you have to do the Mapping Load is best option
Mapping Load * inline
Load * inline
thanks all. good example anand
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 fixed numbers I have only 15 in my excel. thanks for the explanation
Thanks If you have more numbers like in 1000+ then go with Marcus Suggestion.
Okay anand thanks.
Retrieving data ...