topic Re: Data in QlikView

Data

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Data

tresB — Fri, 26 Aug 2016 06:09:27 GMT

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 ?

Re: Data

arulsettu — Fri, 26 Aug 2016 06:16:48 GMT

may be like this

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

Re: Data

qlikview979 — Fri, 26 Aug 2016 06:21:03 GMT

Hi All,

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

regards,

Mahesh

Re: Data

tresB — Fri, 26 Aug 2016 06:27:47 GMT

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 ':');