AnsweredAssumed Answered

Is there a way to combine multiple records(based on condition) into single record

Question asked by naveenaboppana558916 on Jul 11, 2016
Latest reply on Jul 12, 2016 by Srinivas Chandrakanth Vangari

Hi,

I have a Text file source,where i need to combine Multiple records  to into single record based on Some conditions.Any ideas?

 

Conditions:

When ever I encounter a flat file source record starting with string "start" (Condition1).

When ever I encounter a flat file source record starting with string "end"(Condition2)

Now i want entire records which falls  b/w the above conditions into one record.

Example:

Header

Record1

Record2

start

Rec3

end

Rec4

Rec5

start

Rec6

end

Expected Output :

start Rec3 end

start Rec6 end

Outcomes