Rename column names that has square brackets in name

[gandalfgray]

Hi

I have a select (MDX)  that returns column names like [Period].[Month].[MEMBER_CAPTION].

I would like to simplify those kind of names

but

Load [Period].[Month].[MEMBER_CAPTION] As Month

does not work

and

Load [[Period].[Month].[MEMBER_CAPTION]] As Month

does not work.

Is there a way to rename column names containing square brackets?

[tresesco]

You may want to try like:

rename field (using mapname | oldname to newname{ , oldname to newname })

Or,

Rename field [ABC] to ABC

[Gysbert_Wassenaar · Accepted solution]

Use one of the other quote options. For example double quotes:

Load "[Period].[Month].[MEMBER_CAPTION]" As Month.

See this blog post for more information: QlikView Quoteology

[gandalfgray]

Thought I tried that...

Thanks!