Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Using LEFT JOIN after MAPPING LOAD

Dear Qlikview experts,

I have a problem while using LEFT JOIN after Mapping statement. I need to join tables many times, and in-between I'm doing a MAP condition. After I've specified the MAPPING LOAD statement, I cannot JOIN my previous table anymore, cause it renames the table into the name of mapping condition.

This is what I mean:

Map-Join.JPG

My table, that should have the name of '$(vTableNameED)' has the name 'MapDimTitle'.

Could anybody help with that?

Thanks in advance.

Tags (2)
3 Replies
MVP
MVP

Re: Using LEFT JOIN after MAPPING LOAD

Sorry, I don't understand the issue. What do you mean with

"My table, that should have the name of '$(vTableNameED)' has the name 'MapDimTitle'."


MapDimTitle is your mapping table is not part of the final data model.

Not applicable

Re: Using LEFT JOIN after MAPPING LOAD

I have a table named 'ED' (the name is saved in the variable '$(vTableNameED)'). And I have the structure like this:

ED:

Load * From ...

LEFT JOIN

Load * From ...

LEFT JOIN

Load * From...

...

And then inside those joins I need to specify a mapping condition (MapDimTitle). After that I want to return to joining the ED table, like is shown in the screenshot. So after mapping load I write:

LEFT JOIN ('ED')

Load ApplyMap..... From ...

But instead of joining the ED table the QlikView renames the table into 'MapDimTitle', and breakes there...

Is it clearer? Do you have any idea?

MVP
MVP

Re: Using LEFT JOIN after MAPPING LOAD

Could you post your document log and / or complete script? You can enable the log in Settings - Document properties - General tab.

Community Browser