Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert string to float value in a file in Data Management EPBCS

edited Jul 19, 2023 8:20PM in Planning 1 comment

Hello Everyone,

I'm trying to load data using a file in Data Management, when I try to run rule for "Import", it throws warning "No records found for the period".

Looks like the file has string values and it has to be convert to float values.

We have exact same rule in HP, but there is jython script to handle that.

Note: There is no issue with dimension mapping and period mapping, attaching log for reference.

Attached the script we have in HP and epbcs log

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!