Cross tab with new column headers displayed as date

Hi,

See attached workflow. I want the new column headers to have Date format "%d/%m/%y" so that when I open the output in Excel, it will automatically recognise them as dates.

I tried to create [Period2] being a string field with the required format, and use that to create the new headers, but Alteryx still converts the "/" to "-".

I don't want to manually rename fields as this is part of a rolling forecast so the headers will change each month going forward

Any ideas?

Cross-tab example.yxzp

Preparation

Accepted answers

BenMoss

There is a known issue with the cross-tab tool which converts special characters to underscores.

There is an easy workaround, especially in your instance where you know all underscores should be slashes.

You can use the dynamic rename and do...

repalce([name],"_","/")

Ben

All comments

BenMoss

There is a known issue with the cross-tab tool which converts special characters to underscores.

There is an easy workaround, especially in your instance where you know all underscores should be slashes.

You can use the dynamic rename and do...

repalce([name],"_","/")

Ben

mb1824

Thanks @BenMoss

vaughangary

Thanks, however that does not work for dynamic situations. Are there plans to fix the Cross Tab feature?

Gary

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703