I have a line item where the data is Imported from another module in the model
I have also created another line item in the same module which is set to No Data that I Import to the line item mentioned above to clear it before running the previously mentioned import action.
I have these 2 Actions in a process (1st is the CLEAR Action and 2nd is the standard import of values Action)
The Clear Import action is failing (as stated in the Action Report - see below for Screenshot) but it does work and clears all the values. The Process does not run the 2nd Action which I assume is because the 1st Action has "Failed"
I'm struggling to understand how the import could be failing as it is from 1 line item to another in the same module and hence there should be very room for error...
In your error message you can see that there were 8 failures because there was an "Invalid date or Timescale". In your mapping, you can see that you have Time set to the column headers and then you have Versions and line items set to fixed, Becasue of this, it is seeing it as a Time Period, and giving an error because there is no time period named Version or Line item. There were 8 failures in your message, 4 from versions and 4 from line items.
As @Harsha_D mentioned, you can map the columns via the import. I would also recommend making sure that your saved view is set up to only show the line items and versions that you have selected in the import, and then when you select the columns to use in the import they should map automatically.
I'm just recreating the error in a test model but I cannot get the Import to Fail like I did in my example above. When I run a process with an Action that has the same issue as above it will fail on lines items but it will not fail the entire import like above & hence will run the 2nd Action in the process
Any idea why the entire Action above failed rather than those specific items?