Register

Question on how to map miss-matching dates

neg177
Regular Contributor

Question on how to map miss-matching dates

Hi,

 

I would like to know how to match my flat file's when my dates on my flat file and Anaplan do not match. Usually I end up having to manually match them. Please advise. snap shot attached below. 

 

neg177_0-1618000039910.png

 

 

 

Thank you  

17 REPLIES 17
rob_marshall
Moderator

Re: Question on how to map miss-matching dates

Hey @neg177 

 

Help with your mapping, why are the targets the same date separated with a "-"?

 

Rob

neg177
Regular Contributor

Re: Question on how to map miss-matching dates

Hi Rob,

 

I'm not sure why the dates are separated with the "-", We tried to export data from Anaplan to add additional data in Excel, and when we tried to import the csv file back into Anaplan we saw that the dates then had the separation. Leading to the manual mapping. 

rob_marshall
Moderator

Re: Question on how to map miss-matching dates

@neg177 

 

So that is very odd.  In the excel, how are the dates formatted?

neg177
Regular Contributor

Re: Question on how to map miss-matching dates

We changed the dates to be formatted to match Anaplan. Shown in the Snap Shot below. We also tried other formats and still not automatically mapping the dates. 

 
 

 

rob_marshall
Moderator

Re: Question on how to map miss-matching dates

@neg177 

 

Can you get a snap of the Excel?  Excel is routinely the devil because it changes the format fo the cells.  Remember, when mapping dates from Excel, it is best to use a number like 20190501 (YYYYMMDD).

 

Rob

neg177
Regular Contributor

Re: Question on how to map miss-matching dates

Yes, attached is the snap shot of the Excel File. 

rob_marshall
Moderator

Re: Question on how to map miss-matching dates

@neg177 

 

Can you click in one of the cells with the date and take a picture of that?  Also, you might want to check out the delimiter when you uploaded the file.

neg177
Regular Contributor

Re: Question on how to map miss-matching dates

attached is a pic of the data in one of the cells. Also to eliminate that delimiter issue should we import it as a txt verses a csv?  

rob_marshall
Moderator

Re: Question on how to map miss-matching dates

@neg177 

 

And can you post the mapping tab on the action?