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.
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
