Delete Specific Data

[pgalvezt]

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!

[luismadriz · Accepted solution]

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

[luismadriz]

Other function could be SubStringCount() I think

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