It seems that you are not having a unique key in your table due to which it performs the cardigan join or many to many relationship.
you can avoid this through
using distinct keywords in select or load statement.
you can create a composite key to join with tables
these are the assumptions based on your questions. there will be other possibities based on your script and data which can be analysed once you can share your script or dummy data
Can you ellaborate little bit more? with some sample example, the output which you are getting? what is your expected output? How you did the join those table? if possible share your script too.
Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
