Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
bxprokop
Contributor II
Contributor II

JOINS

I have an issue I am related to JOINING table.  Currently, I have two table I am try to JOIN but cannot achieve outcome I would like.  Ultimately, I want to create a table that contains everything from Table 1 and Talbe 2 in the example attached.  In the end, if a PROVIDER in Table 2 only performs service 1,2,3 and 5, I want the Final Table to contain all Services from 1 - 6 eventhough the PROVIDER didn;t have any data in Table 2.  Is that possible?  If so, how would accomplish it?  See examples attached.

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

Hi

have a look at the attach example

View solution in original post

1 Reply
lironbaram
Partner - Master III
Partner - Master III

Hi

have a look at the attach example