Solved: Re: Row Deletion - Qlik Community

Report Inappropriate Content · ‎2017-06-30

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 · ‎2017-06-30

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

View solution in original post

eliran · ‎2017-06-30

Hi Alison,

You will need to reload the data, either by partial reload, or full reload.

What is the scenario you're trying to go for?

Eliran.

kaushiknsolanki · ‎2017-06-30

Hi,

Do you mean to say that when you load the data in qlik, you are getting null values for rows like 7,8 and 9?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2017-06-30

Hi Eliran,

Thank you for your response.

How would you do that?

A colleague of mine uploaded a table to Qlik which included a totals row. So ideally he'd like to be able to delete that from the data post-upload. I just made this example data set for ease.

Report Inappropriate Content · ‎2017-06-30

Hi,

That's not a problem, I would just like to be able to remove the data found in row 6.

kaushiknsolanki · ‎2017-06-30

Hi,

There are couple of ways you can do that.

1. Use the basic transformation steps available when you load the data and use the delete option to delete the record manually.

2. If you have the Total Keyword in that raw, you can use the where clause to not take rows where the keyword is Total.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

eliran · ‎2017-06-30

Hi Alison,

It's something that needs to be taken care of in the ETL stage, you can't remove it when you're "viewing" the model.

Your only way to do it "on the fly" is filtering it manually.

So, if the field name is StudentID, just choose the total row value (29w) and then right click the field and click 'select excluded'.

You don't really have an ability to delete the data when viewing the app.

Hope it helps,

Eliran.

Report Inappropriate Content · ‎2017-06-30

Hi Kaunshik,

Thank you for your response.

Please can you provide a more expansive description, I don't really understand.

aarkay29 · ‎2017-06-30

Hi

You can do something like this in the script if you don't want to load the lines

Load

*

From Table

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

similarly you can apply this for your scenario.

Report Inappropriate Content · ‎2017-06-30

Hi Aar,

Thank you for your suggestion. But, I haven't been able to make it work.