Mapping Issues due to dates

neg177
neg177
in Integrations and extensibility

Hi, 

 

I'm currently having mapping issues with the current Flat File I'm trying to load into Anaplan. It is saying it can not match up the dates, but I'm hoping I will not have to manually change the dates on my flat file verses getting a way for Anaplan to read the dates to map the data. Please advise. 

neg177_0-1640018652833.pngneg177_1-1640018914703.pngneg177_2-1640018993203.png

 

 

 

 

Thank you 

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓

    @neg177 

    Gotcha! Let's take this step by step. You will continue to get the error because Anaplan doesn't know what to do with the 2nd column "order". Since your line items are in column 1 and your lists (time) is in the column headers, you've exhausted all the mapping options. I can only think of two ways you can get the magical green checkbox. First, You'll have to remove the order column from your source file since it doesn't seem to be needed. Second, create a list called "order" with one list item in it called "1" and change your source file to be "1" for all rows.  

     

    This will not work:

    JaredDolich_0-1640035470706.png

    This will work Option 1:

    JaredDolich_2-1640036501518.png

     

    This will work Option 2:

    JaredDolich_1-1640036405968.png

     

     

Comments

  • JaredDolich
    JaredDolich

    @neg177 

    You should be able to use Y-M-D "periods", or try using a custom fixed-position pattern YYYY-MM-DD

    Make sure you match the date format of the SOURCE not the TARGET.

  • neg177
    neg177

    still getting same error when I customize the date setting. 

    neg177_0-1640026907473.pngneg177_1-1640026950668.png

     

  • neg177
    neg177

    My apologies, I was trying to map to the Target and not the Source like you said. Now I just get this failed error...

    neg177_0-1640027209784.png

     

  • JaredDolich
    JaredDolich

    @neg177 

    Your source data is Y-M-D

    Try that combination or use the custom build code with YYYY-MM-DD or YYYY?MM?DD

  • neg177
    neg177

    I believe I have my time set correctly now, but I still get the following error below. The data is still getting loaded into the Module, but I need no errors at all because we are trying to create a OneCloud connection and we need to make sure our mappings have no errors for this. 

    neg177_0-1640032474381.png

     Thank you 

  • JaredDolich
    JaredDolich

    @neg177 

    Almost there. Almost there. Can you please show me the time format you are using? Should be Date, Y-M-D, or Custom build, like YYYY?MM?DD. 

    See? Your source is YMD

    JaredDolich_0-1640032817615.png

     

  • neg177
    neg177

    Yes Almost there lol, thank you so much for your patience. I have used both the Y-M-D and YYYY?MM?DD and still getting the same error with both. Its just that error saying "Expected 2 or 4 digit year in date/period". 

    neg177_0-1640033451545.png

     

  • neg177
    neg177

    Thank you so much for your help. Your awesomely awesome!

Categories