I am in a fix and would really appreciate your help.
Does the joins in SQL and Qliksense occur in the same way.
I have a SQL query for example:
select
t1.A,
t2.B,
t1.C,
t1.D
from table t1, table t2
where t1.A=t2.A
and t1.C="hello"
result table is a hit with about 123 datapoints.
In qliksense when i try to extract the data using (data connections by the way) the data loaded is more than 123. The two tables are loaded individually and hence end up having 123 data points from table 1 and more than 123 datapoints from table 2. To mention additioonally i dont know how to implement the where codition for both the tables. do i join them first and then apply the where or how does it work. i am utterly confused.
...do i join them first and then apply the where or how does it work...
YES, join first and then try using filtering with where clause. Because before, joining you can't compare one field from one table to another field from another table.
...do i join them first and then apply the where or how does it work...
YES, join first and then try using filtering with where clause. Because before, joining you can't compare one field from one table to another field from another table.
thats my problem . irrespective what kind of join i do . i get a multiplcation productr of the data from two tables. and sql gives me the filtered data with all the filed names from both the tables and it is 557.
