Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Andre Mattos Junior (AndreM7824)
EY

EY
BR
AndreM7824 Member since 2017 8 posts
EY
Posted: Jan 25, 2018
Last activity: Jan 30, 2018
Posted: 25 Jan 2018 8:35 EST
Last activity: 30 Jan 2018 8:27 EST
Closed

Parsing data to excel without "Green Triangle"

Hi pega community!

Im facing a big problem, im parsing some data from SQL to a excel.

I made a simple automation just to figure out how to get rid from the "Green Triangle" on excel.

So, no matter how the data comes from the SQL (nvarchar,number,float) and excel columns are configured (General, Text, Number), this green triangle always appear.

My next process from this one is running a macro that will sum a column, and with this green triangles is not possible to sum this column.

Note: Numbers in Brazil need to have comma decimal separation.

Thanks!

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 30 Jan 2018 8:27 EST
Andre Mattos Junior (AndreM7824)
EY

EY
BR

Hi People,

I've found a way to get rid from the triangles.

It was pretty simple, first i was using a procedure to return the data for Excel. And no matter wich type of data used for numbers, the green triangle was always activated on excel.

So i made a modification, rathen then using procedure calling i started used the SQL query (Formating all numbers to a varchar). Using this method somehow pega converts this decimal to a number that is possible to use sum formulas on excel).

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice