Skip to main content

I have a CSV file with a column indicating  the month dimension. It is “Jan 25”, “Feb 25”, etc. 

On the initial import screen it looks correct,



however, as soon as I map it to the Pigment property (Month dimension type) it shows in the preview as 


My imported data is all loaded into the wrong months. 

I want it to just take the exact value in my CSV as the name for the Month dimension instead of converting a date. I tried double-quoting the field in the CSV, that didn’t help. Loading it into a regular text property works fine so it doesn’t appear to be an issue with the source data itself. 


 

@geoff_chovaz Can you try to convert your ending date format as 03-01-2025 in Excel, then map it to month dimension. I think pigment consider your ending date as date format instead of text format.

 

 


Yes, that’s what I had to end up doing (not in excel, but in the source). 

It’s a little unintuitive that all other dimensions can be mapped directly to the default property, but dimensions tagged as time have to be in a date format that then gets converted. I was (incorrectly) assuming that if I wanted to load data to Q1 22 I could just pass that in, but you can’t. Youd have to pick a date within that quarter. 


Reply