Inner join resulting cross multiply records

[bickyqlik]

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>

[lukas_]

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

[bickyqlik]

Would you be able to share a sample example to me please to refer

[bickyqlik]

Any sample example to refer. I am new to Qlik and so not getting fully what been suggested

[Or]

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.