Decimal Point is getting Rounded in Flat File Load

[former_member266270]

Hello,

I'm trying to load a flat file in .CSV format. In the system the values of the KFs are decimal and when it is loaded into PSA, the values are getting Rounded. Eg. If the Value is 34.67 it is turning into 35. Is there any settings that can be changed in the file and what could be reason for this change?

Thanks in Advance!

[Former Member · Accepted solution]

Hi,

1st open CSV file in notepad and confirm that 34.67. If yes, Then make change in properties of Datasource as shown in below figure.

Fig. Change Decimal Place from 0 to 2 from Proposed Tab

Regards,

Sushant