topic Re: Delete records in cascade in QlikView

Delete records in cascade

Tue, 28 Jul 2015 09:18:50 GMT

Hello;

I have a file with data from 2004 to 2015. I want to have only the data from 2015.

I deleted rows from the fact table where date<2015, but i like to delete all in cascade.

I want to delete all rows from all tables that have no relation with the fact table with data of 2015.

I can delete rows from all tables ono to one, but there are more than 50 tables.

I want to know if exists a way to delete all with one instruction? Something like DELETE IN CASCADE

Thanks

Fernando

Re: Delete records in cascade

marcus_sommer — Tue, 28 Jul 2015 09:59:54 GMT

I don't think that there are many possibilities to automate such data-reduction then you need to consider the key-fields and the relations between all tables. But maybe you could use statements like KEEP or (not) EXISTS to make that handling easier.

- Marcus

Re: Delete records in cascade

Kushal_Chawda — Tue, 28 Jul 2015 10:06:10 GMT

It's not possible in Qlikview.But you can do it by using left join with Exist fuction.

For example

Fact1:

load *

From Fact

where Year<2015

left join

load *

from dimension1

left join

load *

from dimension2

Fact2:

load *

from Fact2

where exists(KeyfromFact1, keyfromFact2);

Re: Delete records in cascade

Tue, 28 Jul 2015 11:00:03 GMT

Thanks Kush

Re: Delete records in cascade

Tue, 28 Jul 2015 11:00:37 GMT

Thanks Marcus