topic Re: Update field values from other table in QlikView

Update field values from other table

prachisangewar — Fri, 28 Nov 2014 09:21:54 GMT

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.

Re: Update field values from other table

datanibbler — Fri, 28 Nov 2014 09:30:01 GMT

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

Re: Update field values from other table

Fri, 28 Nov 2014 09:39:21 GMT

Hi,

You Can use inner join directly in edit Script.

Select * from A;

inner join

select * from B;

Regards,

Joshmi

Re: Update field values from other table

prachisangewar — Mon, 01 Dec 2014 02:02:01 GMT

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

Re: Update field values from other table

Jagruti — Fri, 01 Jul 2022 12:25:43 GMT

I also want the solution for the same problem to write QlikSense script. Please help.