topic Re: Want to replace column name with today's date in Getting Data In

Want to replace column name with today's date

sabari80 — Wed, 01 Nov 2023 18:51:19 GMT

I have a query to display following 3 fields

| table pp_user_action_name,Today_Calls,Avg_today

i want to replace 'Avg_today' column header with today's date like '11/1/2023'

is it possible?

Re: Want to replace column name with today's date

richgalloway — Wed, 01 Nov 2023 20:28:43 GMT

Here's one method. There may be others.

| makeresults | eval pp_user_action_name="foo",Today_Calls=42,Avg_today=3 | table pp_user_action_name,Today_Calls,Avg_today | rename Avg_today as [| makeresults ``` Get today's date and format it ``` | eval today=strftime(now(), "%m/%d/%Y") ``` Return only the value of the today field ``` | return $today]

Re: Want to replace column name with today's date

sabari80 — Wed, 01 Nov 2023 20:49:22 GMT

its working. can we append any string with this date? For Ex: 11/1/2023_Response

Re: Want to replace column name with today's date

richgalloway — Wed, 01 Nov 2023 20:57:46 GMT

Sure! Just use the concatenation operator (.) in the eval command.

| eval today=strftime(now(), "%m/%d/%Y") . "_Response"

Re: Want to replace column name with today's date

sabari80 — Wed, 01 Nov 2023 21:32:51 GMT

Thanks. i am all set.