Cross Tab converting Date to String

[rohin92]

Hi All,

My output from the Summarize tool has 3 columns namely 

1. Country

2. Value

3. ReportDate

Report Date has date for 3 months for example 2023-08-01, 2023-09-01, 2023-10-01

When I do cross tab to convert Report Date into 3 columns for the 3 months, I get output with column headers as 2023_08_01, 2023_09_01 & 2023_10_01

I want the column headers to remain in the same format when I do crosstab.

Before Cross Tab

Country	Value	Report Date
India	10	2023-08-01
India	15	2023-09-01
Japan	20	2023-10-01

After Cross Tab

Country	2023_08_01	2023_09_01	2023_10_01
India	10	15	Null
Japan	Null	Null	20

Why does "-" get converted to "_" in date

how can I get the date in original format as column header

[alexnajm · Accepted solution]

Unfortunately this is just the behavior of the CrossTab tool - use a Dynamic Rename to replace those underscores back with hyphens!

[rohin92]

@alexnajm thank you so much it worked for me

[alexnajm]

Fantastic! If you could accept it as a solution then, that would be great 😊