Data

[qlikview979]

Hi Experts,

I have one field in excel name like " DATA" in that field data like  this

Data

1,2,3,4,5

Expected Output:-

Data

one,two,three,four,five

is it possible?

[tresesco]

Possible. Can you give a bit more detail, like:

-Max number you would have in such data

-Max length of such string

in your real data set ?

[arulsettu]

may be like this

Pick(Match(DATA,1,2,3,4,5),'one','two','three','four','five')

[qlikview979]

Hi All,

By using Mapping Or Pick . How can we get that ?

regards,

Mahesh

[tresesco]

Try like:

MapTab:

Mapping Load * Inline [

Num, Word

1, One

2, Two

3, Three

4, Four

5, Five];

Load

  Concat(InWord,',') as InWordFinal;  // This will give you single line output

Load

  *,

  ApplyMap('MapTab',NumSeparated) as InWord;

Load

*,

SubField(Num,',') as NumSeparated Inline [

Num

1,2,3,4,5

]  (delimiter is ':');