topic Re: Joins Issue in QlikView

Joins Issue

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

Hi Experts - Just help me understand what i should do, when i have 2 tables with No unique value(in any of the table).. irrespective of doing the field concatenation.. What is the best way to join these 2 table? Below is an sample of data how my data looks ,,,

Table1
Customer	Material
AAA	111
AAA	111
AAA	222
BBB	333
BBB	333
CCC	444

Table2
Customer	Material1
AAA	111
AAA	111
BBB	333
BBB	444
CCC	444
CCC	444

Re: Joins Issue

sunny_talwar — Mon, 05 Feb 2018 12:49:45 GMT

What is the output that you expect to see after they join?

Re: Joins Issue

bharani8 — Mon, 05 Feb 2018 12:59:49 GMT

Hi Sunny - I expect all the values as i have the 3rd column in each table.. Say For Eg., in Table 1 i have 3rd colm as Country and in Table 2 i have 3rd column as Color.

Re: Joins Issue

sunny_talwar — Mon, 05 Feb 2018 13:02:09 GMT

So, why are you looking to join? Why not just concatenate?

Re: Joins Issue

pradosh_thakur — Mon, 05 Feb 2018 13:20:06 GMT

"Don't join Use concatenate Instead"

Re: Joins Issue

bharani8 — Mon, 05 Feb 2018 13:37:10 GMT

May be am not able to convey the right message above... Below is the Table join of my actual data now..

i get below msg while reloading

"One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog."

I see the data as expected now with the below table structure..but my question is , Is this table structure fine to develop DB? If Yes, What are the dis-advantages using this?