My apologies - attached here.
GanguP - SnapLogic is a streaming platform, meaning it only retains context of the current document being processed. I'd like to fully understand the requirement before showing you one solution vs another.
Before offering a solution, can you clarify your use case? Do you need to always combine 4 rows following a blank linedata value? Or could there be any number of rows (0-N)?
Hi Kory. Thank you for a quick response. Below is the format of the file I am trying to parse. Below are the steps I am taking
1) Use Fixed width parser to filter out lines that are not needed.
2) Used mapper to assign the LOCATOR2_FLAG. Below is the logic.
($LINEDATA.substring(0,9).trim()>='0000000000' && $LINEDATA.substring(0,9).trim()<='9999999999') &&$LINEDATA.substr(38,1) .trim() == "-"?'Y':'N'
Hello Prajwal,
Is the input always going to be the same (the number of documents)? If yes, then you can use a Gate Snap to gather all of the documents into a single array and then combine all of the elements into a single object.
For more information, please refer to the attached pipeline.
Let me know if this helps you.
Regards,
Aleksandar.
I have one question, will the gate snap works in the child pipeline? this child pipeline is triggering from the ultra parent pipeline.
Thanks Aleksandar_A and svatada, I'll give a try with these methods.
