Delete records in cascade

[#1]

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

[marcus_sommer · Accepted solution]

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

[Kushal_Chawda]

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);

[#4]

Thanks Kush

[#5]

Thanks Marcus