HELP IN IMPORTING DATA

Look when i am importing weekly data in my INV01 when i want to map time with column headers
Time (2019-12-29 - 2020-01-04, 2020-01-05 - 2020-01-11, 2020-01-12 - 2020-01-18, ...)
this shows up but data in my 'csv' and 'inv' in form of WEEK 1 FY20 but in mapping dialog it shows Time (2019-12-29 - 2020-01-04, 2020-01-05 - 2020-01-11, 2020-01-12 - 2020-01-18, ...)

why this how to solve it

and I know its a part of sprint 3 exam but I have already passed it and this was the only question wrong
If i don't solve this and in any case the data is used in conclusion it might lead to mis-match so I am taking this as a precautionary step

PLEASE HELP
thank you

Answers

  • Hi,

    Before going to the time mapping tab I suggest mapping all relevant dimension first and then checking the mapping tabs after that.

  • @pyrypeura Thank-you It worked
    may I know the reason why we should map other dimensions first ??

  • Without mapping all dimension first on time tab it's trying to map empty column name to time dimension which messes up the mapping Anaplan tries to do.