Hi, is there a way to split a record into multiple records? I have read the Data Foundry Expression Ref document but I didn't see any CREATE_RECORD entry. Basically I
need to split a record for each of the PROD_ID that it has and create a new record of it. I have the ff record :
I think the best way to handle this requirement is to write a custom java manipulator. You can read how to do that here: http://docs.oracle.com/cd/E28911_01/PlatformServices.612/pdf/ContentAdapterGuide.pdf
In your manipulator's execute() method, you can look through the different prod_id source properties from the input record and instantiate a record for each prod_id encountered (e.g. Record rec1 = handler.getRecord(inp);). You'd then have to delete the other prod_ids and .emit each record in the loop (e.g. handler.emit(rec1);).