Skip to main content
S
shubhamy3376
June 25, 2023
Question

Modify values in a!queryselection

  • June 25, 2023
  • 6 replies
  • 0 views

Hi Everyone,

I am retrieving column data from db using a!queryselection but need to truncate the values for some columns. Can anyone please help me out, how to achieve this?

Many Thanks!

    6 replies

    harshitb6843
    harshitb6843
    June 25, 2023

    What do you mean by truncate? The round off the value or to delete the column data?

    S
    shubhamy3376Author
    June 25, 2023

    Need to remove the last four digits from the values in a column.

    harshitb6843
    harshitb6843
    June 25, 2023

    You cannot do that with any parts of a!queryEntity. 
    This will happen once you have fetched the data from the DB if you are using a query entity. 
    I will recommend using a custom record field and it will be much more efficient. 
    docs.appian.com/.../custom-record-fields.html

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 25, 2023

    For what purpose? Can you help us with more details about your use case?

    S
    shubhamy3376Author
    June 25, 2023

    Hi All,

    I am using export DSE to excel smart service to extract data into excel, but one column values needs to the modified like to remove the last four digits and then extract into excel. Please suggest some solution.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 25, 2023

    Create a view in the DB to prepare the data.

    Terms & ConditionsAccessibility statement