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.

 

 

Reply


Ask your question here!

Terms & ConditionsCookie settings