cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

Rename column Max(Max(date))

UserID16644
Level V

How to rename column Max(Max(date)) to "date"?

 

I tried:

1. :Max(Max(date)) << Set Name ("date");

2. :Name (Max(Max(date)) ) << Set Name ("date");

3. Column( dt, Max(Max(date))) << Set Name( "date" );

3. Column( dt, :Name (Max(Max(date))) ) << Set Name( "date" );

 

But none of these works

 

1 ACCEPTED SOLUTION

Accepted Solutions
Thierry_S
Super User


Re: Rename column Max(Max(date))

Hi,

When your column name has parentheses or any other special characters, your best bet is the following syntax:

Column (dt, "Max(Max(date))" << Set name ("date");

Note the quotes before and after the column name.

Best

TS

Thierry R. Sornasse

View solution in original post

2 REPLIES 2
Thierry_S
Super User


Re: Rename column Max(Max(date))

Hi,

When your column name has parentheses or any other special characters, your best bet is the following syntax:

Column (dt, "Max(Max(date))" << Set name ("date");

Note the quotes before and after the column name.

Best

TS

Thierry R. Sornasse
jthi
Super User


Re: Rename column Max(Max(date))

I like using same syntax as @Thierry_S suggest (Column(dt_ref, "colname")) but if you want to use the colon syntax  

:"Max(Max(date))" or even better would be :"Max(Max(date))"n. Using Name() is deprecated syntax for ""n. For some additional information regarding names see Names and JSL Rules for Names .

-Jarmo