Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you please post the sample of the row that you are trying to delete
Hi,
I attached a screenshot of the excel file is that's what you're after?
Yes, I'd like to be able to remove it in the data load editor.
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';
Hi,
Thanks so much!
Cheers!!!