topic Re: Replace data in source table in QlikView

Replace data in source table

tamilarasu — Thu, 26 Feb 2015 02:09:04 GMT

Hi,

I have two tables and one is source data and another one is revised. I want to replace the source data with the revised data. Can any one suggest me a data model for this scenario.

Sample data attached.

Also, Is it possible to show the source records which are not available in revised table.

thank you

Regards,

Tamil

Re: Replace data in source table

jagan — Thu, 26 Feb 2015 03:15:14 GMT

Hi,

Try like this

Data:

LOAD

FROM Table2;

Concatenate(Data)

LOAD

FROM Table1

WHERE Not Exists(Cust);

Hope this helps you.

Regards,

Jagan.

Re: Replace data in source table

Anonymous — Thu, 26 Feb 2015 04:39:10 GMT

with only one sql query:

DATA:LOAD *;

SQL SELECT x.Cust as Cust,x.Prod as Prod,x.Type as Type,y.Price

from Table1 x,Table2 y

where x.cust=y.cust and x.Prod=y.Prod and x.Type=y.Type

union all

SELECT x.Cust as Cust,x.Prod as Prod,x.Type as Type,y.Price

from Table1 x where not exists(select * from Table2 y

where x.cust=y.cust and x.Prod=y.Prod and and x.Type=y.Type)

order by x.Cust,x.Prod,x.Type;

Re: Replace data in source table

vinay_hg — Thu, 26 Feb 2015 05:23:27 GMT

Hi try Applymap from second table to first table, and use if condition, if matches then applymap result else use the same result from A table.

"if(table1.key=table2.key, applymap( from table 2 to table 1 to get price), table1.price)as price " in table 3 price column.

Re: Replace data in source table

tamilarasu — Thu, 26 Feb 2015 05:57:21 GMT

Thank you Jagan, Antonio and Vinaykumar.