Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
YanMin
Contributor II
Contributor II

Table Join

Hi, I am quite new to Qlik sense.

I would like to join my two tables in following. 

Table-1

YanMin_0-1617868548136.png

Table -2

YanMin_1-1617868574319.png

Final Table 

YanMin_2-1617868597534.png

 

I would like to have as Final table as they will not be in different rows if Product Name is Same.

Can anyone assist?

Thanks in advanced.

 

1 Solution

Accepted Solutions
PrashantSangle

Hello @YanMin ,

 

Join work on common fields. In your code I can see there are 3 common fields & they are

Product Name, Platform & FileName.

In above output check for same product Name you have multiple FileName. 

To avoid this you can rename one of FileName field or remove that fields.

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

6 Replies
rwunderlich
MVP & Luminary
MVP & Luminary

1. Load the first table as Table-1. 

2. Then join the table-2 data to table-1.

Outer Join(Table-1)
LOAD
     *
From Table-2 source...

-Rob

YanMin
Contributor II
Contributor II
Author

Hi Sir thanks for the help again. When I load, it goes as two separate rows. I want to be in same row. I have attached my codes as well. 

 

YanMin_2-1617961814655.png

 

YanMin_1-1617961778534.png

 

rwunderlich
MVP & Luminary
MVP & Luminary

Can you confirm that the "Product Name" values are identical?  If you put "Product Name" in a listbox does every product appear only once?

The other issue is that I'm not sure a Join will work correctly using a wildcard load. Try modifying the second load to load to a table. Then from that table using Load Resident. Or just leave them as separate tables and let Qlik do the work.

-Rob

YanMin
Contributor II
Contributor II
Author

Hi Sir, 

Yes the list box appear only once for the above code which I filter for shopee. but as I have loaded for Lazada as well, if not filter, some products are duplicate with exact same name. In this situation, how should I load datas? 

 

PrashantSangle

Hello @YanMin ,

 

Join work on common fields. In your code I can see there are 3 common fields & they are

Product Name, Platform & FileName.

In above output check for same product Name you have multiple FileName. 

To avoid this you can rename one of FileName field or remove that fields.

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

YanMin
Contributor II
Contributor II
Author

Hi,

The problem is there. My filename make duplicate rows. Thank you so much.