HI,
I'm trying to import data(below 1) into module(below 2). And mapping are(below 3 4).
But result was below 5.
Please let me know if there is solution.
Best, Regards,
Hi @Takamasa ,
Try Custom pattern as shown below,
Regards,
Vignesh M
Hi,
Can you format your Date column in excel as shown below and try the import.
HI @Takamasa,
The mapping looks good but i think the issue is because of the language for month names. Can you please change it to 'English' as your import file has month names in English? I hope this should work.
Let me know if you are still facing the issue!!
Kavin.
I tried custom(DD-MMM-YY) and changed to ”English"。But error showed.......
I meant in your previous approach!!
英語 means English in Japanese.
So I adjusted, but can't import...
I got it by changing dd-mmm-yy in excel and format from date to text on module, and mapping from column header to fixed line item.
So I think my excel data was thought as text.
What should i do to change format to date?(I want to use this data as date because of function)
I got it!
But i have one question.
On the source, when i selected column headers(previous photo), this resulted in error,.
But when i selected fixed line item(below), result in success.
There are difference between column header and fixed line item?
Best regards.
Both the Column Header and Fixed-line item does the same job, we use these options based on the target count in import.
if we have only 1 target, then we can use the fixed-line item or Column header option. If it's more than 1 target, we have to use the column header.
~Vignesh M
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…