i want to know how i can delete imported data
@Sharmascy
Option1:If you want to wipe out the data from the module then the best way is to create a line item formatted as No data and Import this line item into a line item which contains data. This will remove the data from the line item and make it zero
Option2: Another way is to select the “clear target prior to import” within an import action. But this has a caveat which means that the number of items loaded earlier has to be exactly the same when you try to load it with zeros..
I would suggest you go with option1
Misbah
Agree with @Misbah - best way is through an action. If you want an immediate delete and are okay doing it manually, you can just change the formula of the line item you want to delete to blank or 0, then remove the formula. If you are attempting to delete a delta load, that's much trickier. For that you need to have a Boolean that identifies which list item was changed. Some people use this method, which I believe is considered best practice. I sometimes just load a line item that contains a time stamp then use the MAX function to determine the last load. If the list item matches the last load timestamp then I know it's a delta.
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
