Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to use Qlikview for ETL.I have two tables, e.g A and B
I want to update some values for a column in table A from a column in table B by joining them using inner join.
I want to do this in the Script.
Could anyone suggest me any solution for this please.
Thanks.
Hi,
QlikView is an ideal tool for ETL tasks.
You already seem to know how to do this. If you're sure an INNER JOIN will do what you want, off you go:
- Table_B should be loaded first, then you can use a RESIDENT LOAD for the JOIN; It sometimes doesn't work
when you try and join directly from the primary LOAD.
- Specify the keyword INNER JOIN (it's not necessary, but I'd suggest to also specify the name of the table you
want to join to in brackets)
- After the keyword, write the LOAD of the fields you want to join to the table (a unique key (may be several fields, but you must rename them to match) has to be included in the LOAD)
HTH
Best regards,
DataNibbler
Hi,
You Can use inner join directly in edit Script.
Select * from A;
inner join
select * from B;
Regards,
Joshmi
Hi,
Thank you for the reply,but I need to overwrite the column values of one table from the matching column in the second table.could you please give an example of the script in qlikview.
In simple sql the script would be
"update tableA set column1=column2 from tableA A
inner join tableB B on A.key=B.key
where a.coulmn3='abc' "
How can i do this scripting in qlikview.
Thanks a lot
I also want the solution for the same problem to write QlikSense script. Please help.