Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hI,
I am having 2 tables wit same id.how to join that 2 tables based on id. shall i use join or mapping function...
Hi,
load fields from tables like this:
LOAD
"Table1_id" as [ID]
....
LOAD
"Table2_id" as [ID]
...
just give the fields you want to join the same name.
Regards
Hi,
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.
Regards,
Kaushik Solanki
Hi,
load fields from tables like this:
LOAD
"Table1_id" as [ID]
....
LOAD
"Table2_id" as [ID]
...
just give the fields you want to join the same name.
Regards
YEAH ITS WORKING...