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

Grouping or splitting the records in ICS

edited Oct 17, 2017 7:00AM in Integration 5 comments

Summary

Grouping or splitting the records in ICS

Content

Hi All,

We are getting source file in below format :

x1 , x2 , x3 , y1 , y2 , z1 , z2

x1 , x2 , x3 ,y10,y20 , z10 , z20

We need to build two files as per below out of  the source file using the ICS transformation

File 1 :    x1 , x2 , x3  (Only one record)

File 2 : x1 , z1   (Number of records based on Z elements)

            x1 , z2

            x1,  z10

            x1, z20

Please let me know if it is possible using ICS transformations and how it can be achieved.

Thanks in Advance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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