• State Verified Answer
  • Replies 5 replies
  • Subscribers 4 subscribers
  • Views 3597 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

How to override cell values while using Export SQL To Excel

Sirisha N

 Hi All,

I want to manipulate one of the filed value instead of the one's which are available in the Database Table Values.Here we are using Parse SQL to Excel Smart Service .

Suppose let us say ,one of the field in the table has "100" value in the database. But While writing the values to the file which i want to generate by using Parse SQL to Excel Smart Service,value has to be overridden by "200" value in the output file.

Any suggestions would be appreciated.

Thanks in advance.

  Discussion posts and replies are publicly visible

Parents
  • +1

    Hi Sirisha,

    What do you mean by overriding or manipulating? Do you want to process the data, before presenting it in the excel report?

    For Example : Say "100" is the estimate of a stationary usage for half year, and you want to generate the report for an year, you can multiply the field by 2, in the select statement.

    Select itemCount*2, itemName from Stationary where Stationary is the table from which you want to fetch data. Or create a view from similar statement and query the view.

Reply
  • +1

    Hi Sirisha,

    What do you mean by overriding or manipulating? Do you want to process the data, before presenting it in the excel report?

    For Example : Say "100" is the estimate of a stationary usage for half year, and you want to generate the report for an year, you can multiply the field by 2, in the select statement.

    Select itemCount*2, itemName from Stationary where Stationary is the table from which you want to fetch data. Or create a view from similar statement and query the view.

Children
No Data

© 2024 Appian. All rights reserved.