import data into module

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!!

Regards,

Kavin.

Takamasa

I tried custom(DD-MMM-YY) and changed to ”English"。But error showed.......

kavinkumar

HI @Takamasa,

I meant in your previous approach!!

Takamasa

英語 means English in Japanese.

So I adjusted, but can't import...

VIGNESH.M

Hi,

Can you format your Date column in excel as shown below and try the import.

Regards,

Vignesh M

Takamasa

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)

VIGNESH.M

Hi,

Don't change your line item format to text in module.

After you made format change in excel, have you tried to import? Line item keep it as Date format.
Are you still getting error?

Regards,
Vignesh M

Takamasa

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.

VIGNESH.M

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

Takamasa

I see, thank you so much!
i will try to find why i failed importing by column headers.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!