How would I accomplish this:
I'd like to rename my columns either on import or immediately following.
Example name that comes in: [DIM A].[YEAR].[YEAR].[MEMBER_CAPTION]
Name I want to display: Year
@mike_honey - would love to see this demo file. I checked, but perhaps it's no longer in the OneDrive location? Any way for me to access it?