topic Re: Delete Specific Data in QlikView

Delete Specific Data

pgalvezt — Tue, 21 Nov 2017 22:47:49 GMT

Hello,

I have historical data and I would like to erase all data that contains:

Restaur Alamanda

01/01/2013 Alamanda si Benectido

01/01/2014 Alamanda si Benectido

01/01/2015 Alamanda si Benectido

01/01/2016 Alamanda si Benectido

01/01/2017 Alamanda si Benectido

The next year will appear.

01/01/2018 Alamanda si Benectido Must be dissapear too and so on for the entire years.

I attached a xls sample for better comprehenssion,

Thanks!

Re: Delete Specific Data

luismadriz — Wed, 22 Nov 2017 02:14:47 GMT

Hi Pablo,

Maybe you could insert a where clause to exclude those values by looking into that specific text string field (DESC)

Or if in Qlik you could use this:

// After YourTable has been loaded

TableWithoutAlamanda:

NoConcatenate

Load *

Resident YourTable

Where Index(DESC,'Alamanda si Benectido') = 0 AND Index(DESC,'Restaur Alamanda') = 0;

Drop Table YourTable;

I hope this helps,

Cheers,

Luis

PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others

Re: Delete Specific Data

luismadriz — Wed, 22 Nov 2017 02:27:34 GMT

Other function could be SubStringCount() I think

Cheers,

Luis