Extend Function RRS feed

  • Question

  • Hi 

    Is there any way to rename or give alias to extend column name.

    or can i give a extend column name having blank space.

    Thanks in Advance



    Monday, May 20, 2019 2:03 PM

All replies

  • Hello Akash,

    The extend operator can be used to create calculated columns and append them to the result set. For example:

    T | extend duration = endTime - startTime

    AFAIK, although giving the ColumnName is optional, it cannot be a blank space. More about extend here.

    For renaming purposes, have you checked out the project-rename operator yet? The way it works is as follows:

    T | project-rename new_column_name = column_name

    More about this one here. Please check it out and let me know if it works for you!

    Monday, May 20, 2019 2:57 PM
  • Hello Akash,

    Have you had a chance to check if the above response helps? Please let us know otherwise and we'll be happy to assist you!

    Friday, May 24, 2019 10:01 AM
  • Hello Akash,

    Let us know if there is anything else related to this thread that we can assist you with, else please feel free to mark and close this out if any of the above responses have been of help! Thanks again for reaching out!

    Tuesday, May 28, 2019 3:22 PM