topic Re: Mapping load docubt in QlikView

Mapping load doubt

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

Hi Team,

I need a help on mapping load, in Raw data have 5 column,

can I Implement mapping load on that 5 column?Thanks in advance .!

bramkn — Tue, 27 Mar 2018 10:15:56 GMT

1 Mapping Load on 5 columns, No.

You need to make 5 mapping loads or do a join.

Anonymous — Tue, 27 Mar 2018 10:22:02 GMT

Thanks for the reply!!

marcus_sommer — Tue, 27 Mar 2018 12:20:40 GMT

You could concat your fields like:

map: mapping load Key, F1 & '|' & F2 & '|' & F3 from Source;

and fetching your values with somerhing like:

load

subfield(applymap('map', Key, '#NV'), '|', 1) as F1,

....

I use this approach quite often and it worked well.

- Marcus

bramkn — Tue, 27 Mar 2018 12:31:07 GMT

Good call.

suren946 — Wed, 28 Mar 2018 06:28:35 GMT

Post some sample data here so that community can try to help you