Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mapping load doubt

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

5 Replies
bramkn
Partner - Specialist
Partner - Specialist

1 Mapping Load on 5 columns, No.

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

Anonymous
Not applicable
Author

Thanks for the reply!!

marcus_sommer

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
Partner - Specialist
Partner - Specialist

Good call.

suren946
Contributor III
Contributor III

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