I am having 2 tables wit same id.how to join that 2 tables based on id. shall i use join or mapping function...
No need to use join or mapping.
Load both the table. Qlikview will automatically join based in similar names in both the tables.
By default qlikview uses outter join.
YEAH ITS WORKING...
load fields from tables like this:
"Table1_id" as [ID]
"Table2_id" as [ID]
just give the fields you want to join the same name.
Retrieving data ...