How to override cell values while using Export SQL To Excel

Question

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.

Sowrabha Rajashekar · Accepted Answer

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.

harishkumart · Answer

Hi Sirisha, 
You can just change the data using your sql statement. I your case you can use select if(tebleAlias.fieldName=100,200,100) from tableName tableAlias. Hope this helps you.