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 

[eliran]

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]

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

[#4]

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.

[#5]

Hi,

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

[kaushiknsolanki]

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

[eliran]

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.

[#8]

Hi Kaunshik,

Thank you for your response.

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

[aarkay29]

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.

[#10]

Hi Aar,

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