You should be able to recover the data.
1. Create a module with the file.
2. Select the module and choose Create report from the context menu.
3. Create a list report.
4. Click on the run options button and choose run Excel.
5. Open the Excel file which was created.
6. Delete the records that you don't want.
7. Save as what ever file name you want.
8. Use the file as the source to replace the existing uploaded file.
One very important best practice for working with files as a data source would be to put the files into a source control environment. This will allow you to track what changes have taken place and to recover prior versions.
This, obviously, is helpful in cases like this but also will enable you prove to auditors etc. that you have that aspect of a data management system.
It would especially helpful if you have a case where a record ( a row of data ) is lost.
You were able to fairly quickly observe that your data was wrong but there's always the case where the problem is not going to be obvious.
I don't immediately know how to have a system for files such that all changes can be knowable and problems similar to what you encountered could be prevented.
In general, I am concerned about people working with files as data sources without having a data management system in place or even understanding concepts such as records.
------------------------------
IAN HENDERSON
------------------------------
Original Message:
Sent: Tue March 10, 2020 02:58 AM
From: Per Östlund
Subject: Remove rows from Data Model
Hi
I only appended the original file which means that i don't have any original file to re-upload
/per
------------------------------
Per Östlund
Original Message:
Sent: Mon March 09, 2020 09:58 AM
From: Chris Turner
Subject: Remove rows from Data Model
Delete or edit the rows in your original data and re-upload
------------------------------
Chris Turner
Original Message:
Sent: Mon March 09, 2020 09:55 AM
From: Per Östlund
Subject: Remove rows from Data Model
Hi
Yes, that is a good idea and a nice work around. But does that mean that there is no way of deleting rows, only flag rows as "deleted"?
/per
------------------------------
Per Östlund
Original Message:
Sent: Mon March 09, 2020 09:23 AM
From: Buddhi Gupta
Subject: Remove rows from Data Model
If you know criteria to get only those rows, you can create a calculation using that criteria to create a flag and apply filter on that flag to exclude such rows.
------------------------------
Buddhi Gupta
Original Message:
Sent: Mon March 09, 2020 08:53 AM
From: Per Östlund
Subject: Remove rows from Data Model
Hi
I'd like to remove some rows from a datamodel i built since the data that i added by appending has som wrong input. How do i do that id i don't want to replace the whole file?
/per
------------------------------
Per Östlund
------------------------------
#CognosAnalyticswithWatson