Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .!
1 Mapping Load on 5 columns, No.
You need to make 5 mapping loads or do a join.
Thanks for the reply!!
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
Good call.
Post some sample data here so that community can try to help you