Help with SQL JOIN

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

Hi all,

I have a JOIN thats in SQL but i need to do the equivalent in QV but as a mapping load.

My SQL isn't very good so i was hoping someone could help?

This is the JOIN

JOIN (MNF_STKTHEORICPRODUCTION.CONTAINERTOID = OUTBOUNDORDERSTOCK.CONTAINERORIGINID AND OUTBOUNDORDERSTOCK.PARTIALCLOSEDSEQUENCE != NULL) OUTBOUNDORDERID
JOIN( OUTBOUNDORDERSTOCK.OUTBOUNDORDERID = OUTBOUNDORDER.ID) ACCOUNTCODE

any help would be appreciated.

Re: Help with SQL JOIN

rubenmarin — Thu, 27 Dec 2018 14:25:06 GMT

Hi, a mapping table is created using two fields: [value to search] and [value returned].
You have to pass a [value to search] and it returns the [value retuned] of the same row.

What are the [value to search] and [value retuned] in that join?
https://help.qlik.com/es-ES/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Mapping.htm

topic Help with SQL JOIN in QlikView

Help with SQL JOIN

Re: Help with SQL JOIN