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

Summarize multiple lines of data into one in Data integration

edited Nov 6, 2024 7:09AM in Planning 3 comments

Hi All,

I have been trying to set up data integration between NetSuite and NSPB and facing a problem.

We will get multiple lines of data with volume information from NS and load them into NSPB. While processing data, we would like to summarize data by specific key like period, years and entity and put total volume of them into NSPB under an account "Volume". Process ends without error though the result is as below. Source data can be confirmed in work bench that means data import and mapping going OK only summarize of data is not working. Does anybody has advice for this situation?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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