Row Deletion

[#1]

Hello Everyone,

Say I have a data set that looks like this:

Would it be possible to delete the data from row 6 once the data has been uploaded into Qlik?

All the best,

Alison 

[aarkay29]

Can you please post the sample of the row that you are trying to delete

[#3]

Hi,

I attached a screenshot of the excel file is that's what you're after?

[#4]

Yes, I'd like to be able to remove it in the data load editor.

[aarkay29 · Accepted solution]

PFA

Load *

Where [Student ID]<>'29w';

Load * inline [

Student ID, Sex, Enrollment Start, Course

12a,F,12/06/2017,History

63d,M,12/06/2017,Art

15f,M,20/06/2017,Philosophy

16h,G,13/06/2017,History

29w,Q,12/06/2017,Economics

];

when you are loading from any database

Load *

From Database

Where

    [Student ID]<>'29w';

[#6]

Hi,

Thanks so much!

[aarkay29]

Cheers!!!