Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if left join doesn't match?

Hi

I normally use applymap but now isn't working. I want to do the same as the third option of the apply map.

If the key match the field and if not 'missing' or whatever

How can i do that?

thanks

1 Reply
sunny_talwar

After left joining, you will need to use an if statement in your resident load

Table1:

LOAD Key,

           ....

FROM ...

Left Join (Table1)

LOAD Key,

           Dim1

FROM ...;

FinalTable:

LOAD Key,

           ....

          If(Len(Trim(Dim1)) = 0, 'Missing', Dim1) as Dim1

Resident Table1;

DROP Table Table1;