topic Re: Using Applymap() function in App Development

Using Applymap() function

alexsid-qlik — Sat, 16 Nov 2024 07:01:03 GMT

Dear community,

I am trying to use the ApplyMap() function. But it does not create the information I need.

What I want is to connect my Partnumber with the respective name.

I load the mapping data first.

Map1:
Mapping LOAD
    Partnumber,
    Name
FROM MapData;

Then in my main data load I use this

LOAD 
Partnumber, 
ApplyMap('Map1', Partnumber, null()) as Name
FROM MainData;

But it does not connect! What am I doing wrong?

Would be glad for some assistance.

Best, Alex

Re: Using Applymap() function

m_woolf — Tue, 18 Dec 2018 15:01:26 GMT

What you have looks OK to me. What results are you getting? If you're getting nulls, perhaps the Partnumber from MainData doesn't match the Partnumber from MapData.

Re: Using Applymap() function

alexsid-qlik — Tue, 18 Dec 2018 15:05:40 GMT

Hi @m_woolf,

For some Partnumbers I get the matching Name. But additional data like Sales is null.

Then I get the same Partnumbers but without matching Name. Instead the Sales appears. So basically is the two table are not concatenated.

Should I try a concatenate load?

Re: Using Applymap() function

Mark_Little — Tue, 18 Dec 2018 15:09:30 GMT

Looking at the scrip,t the applymap is not the issue.
It sounds like a data modelling issue or possibly an issue with the part numbers not matching. If the part numbers look the same it maybe worth adding a trim() on load to rule out blank spaces.

Mark

Re: Using Applymap() function

alexsid-qlik — Tue, 18 Dec 2018 15:12:51 GMT

Hey Mark,

you were right!

I did not know about the trim() function. Very useful!

Thanks a lot

Re: Using Applymap() function

alexsid-qlik — Tue, 18 Dec 2018 15:14:01 GMT

Seems to be the case...Somehow the numbers included blank spaces.
Thank you!

Re: Using Applymap() function

alexsid-qlik — Tue, 18 Dec 2018 15:25:39 GMT

Actually another problem appeared: Now every Partnumber is appearing twice.
How comes that and how to get rid of it?