What's new in Customer Journeys?

Connect and learn more!
Grouping or splitting the records in ICS — Cloud Customer Connect
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

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


Grouping or splitting the records in ICS


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.


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