- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Row Deletion
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
That's not a problem, I would just like to be able to remove the data found in row 6.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kaunshik,
Thank you for your response.
Please can you provide a more expansive description, I don't really understand.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Aar,
Thank you for your suggestion. But, I haven't been able to make it work.
- « Previous Replies
-
- 1
- 2
- Next Replies »