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!
Discussion posts and replies are publicly visible
What do you mean by truncate? The round off the value or to delete the column data?
Need to remove the last four digits from the values in a column.
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
For what purpose? Can you help us with more details about your use case?
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.
Create a view in the DB to prepare the data.