If you do not specify any Join both the tables cannot be combined into one (two separate tables), but there will be join/relation between the tables, there is Full Outer Join between these two tables.
If u are not mentioning join between two table . it will keep seperate table and create synthetic key and if no of column are same and same name than automatic it will be full outer join.
I have 853 records in Test table and 853 records in Test1 table as well . But with this code whenever I am plotting column A into the front end then row count is 854. Can you please tell me the reason behind this?
If your two tables have one column (field) name same, then there will be Association between two tables by default.
If your two tables or more have more than one column (field) names same then there will be synthetic key created autometically then you need to create link table to remove synthetic key or you need to rename field names as the synthetic key can be removed.
However, if you would like to use join between tables then you need to use Left Join, Right Join, Inner Join and Outer Join.
Please go through and get clear understanding from listed below link,
I have 853 records in Test table and 853 records in Test1 table as well . But with this code whenever I am plotting column A into the front end then row count is 854. Can you please tell me the reason behind this?
Because there is one value in Test that does not exist in Test1 and/or one value in Test1 that does not exist in Test. That means there are 854 distinct values of A. That's what is meant by a full outer join.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Yes,If you are not mentioning type of join then there wont be any join in qlik view but if the fields are same in different tables then there will be association.using only join will make full-outer join But, according to your requirement you can use Left Join ,Right Join,Inner Join .
