Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am doing a inner join for multiple tables.
One table is having 21000 records and second table is having 22700 records
Both tables have one common column name. While doing inner join the resulting table is having 599k records. Ideally it should have <=22700 records but in reality it's cross multiplying. don't know where is the issue.
inner join([<table>])
Load
fields..
from <table1>
inner join([<table>])
Load
fields..
from <table2>
inner join([<table>])
Load
fields..
from <table3>
If your data causes you to have many-to-many relationships, I don't think you can "remove" it. Either you don't do a join, or you can go through an "association" table if you need dimension calculation at an intermediate level
Would you be able to share a sample example to me please to refer
Any sample example to refer. I am new to Qlik and so not getting fully what been suggested
Not really, no. You literally just have to replace the JOIN with a KEEP (or Left/Right Keep as desired). You can check the documentation for Keep if you need more information on that.