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, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
