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
Summary: Workflow does not display detailed error messages and marks success despite partial failures. Impact: Developers and workflow users will be receiving false-positives due to the “Completed Message” despite partial failures, that are present when manually triggering processes and through cloudworks. The expectation…
We have a business requirement of calculating running IRR to calculate the performance fee. Currently, Anaplan IRR function gives 1 final output basis entire cashflow We need running IRR to start calculating the performance fee from the period if the IRR exceeds Hurdle rate This is a highest priority item and needs to get…
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…
