Activity 2.3.8.2 Import into DEM01 Module

Question

I am stuck at Activity 2.3.8.2 Import into DEM01 Module I don't know how to map Time. Could anyone please help with this:

I thought it should be "Patterns with Separators" Y-M but it failed "Expected month name or number in date/period"

I tried all "Match Names" (could not choose Language), "Periods" with "Custom fixed-position pattern" as "YY-MMM", "YY MMM", "YY?MMM", changed "Language for month names" to "English"

Thank you guys so much. .

Hien Dong · Answer

Hi there, I have not opened the file in excel. I’ve read all related topic in community but could not manage to import.

Anyway, I deleted old file and downloaded again.

(changed to Tiếng Anh - means English)

sandeepreddy0021 · Answer

Hi, If you have opened the excel file the time format in the excel might have changed. If so please download a new file and try mapping again without opening it.  The source mapping you have done is correct. In the time tab choose > periods > Y-M > language English. This will work.