Hi,
I would like to know how to match my flat file's when my dates on my flat file and Anaplan do not match. Usually I end up having to manually match them. Please advise. snap shot attached below.
Thank you
Neg
I don't believe you are in the module you are importing the data to for a couple of reasons:
The list you are importing to has the dashes, the "mapped to" matches the list members of the list.
Rob
Hey @neg177
Help with your mapping, why are the targets the same date separated with a "-"?
Hi Rob,
I'm not sure why the dates are separated with the "-", We tried to export data from Anaplan to add additional data in Excel, and when we tried to import the csv file back into Anaplan we saw that the dates then had the separation. Leading to the manual mapping.
@neg177
So that is very odd. In the excel, how are the dates formatted?
We changed the dates to be formatted to match Anaplan. Shown in the Snap Shot below. We also tried other formats and still not automatically mapping the dates.
Can you get a snap of the Excel? Excel is routinely the devil because it changes the format fo the cells. Remember, when mapping dates from Excel, it is best to use a number like 20190501 (YYYYMMDD).
Yes, attached is the snap shot of the Excel File.
Can you click in one of the cells with the date and take a picture of that? Also, you might want to check out the delimiter when you uploaded the file.
attached is a pic of the data in one of the cells. Also to eliminate that delimiter issue should we import it as a txt verses a csv?
And can you post the mapping tab on the action?
attached is the mapping tab on the action we are trying to perform.
The first tab, the Mapping tab and I just realized, you aren't using the Native Time, are you? If not, why not? And do you have a code on this list?
Lastly, it is not the source that I think is the problem, it is where it is going or landing that is the issue. Can you take a look at the list members of your fake time and see why those might have a "-" in it?
I'm not sure what you mean by Native Time?
Are you using the regular Time dimension or a custom list?
we are using regular time.
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
