I have a question on how to resolve splitting a single entry input into mutliple line entries using BODS.
Example we have Column 1, Column 2, Column 3 and the output will have 3 lines with Line 1 value from Column 1, Line 2 value from Column 2 and Line 3 value from Column 3?
Is there a loop that can be utilized inside a Data Flow?
What I had thought of is current using a CASE and a MERGE to resolve this.
Are there a better solution to this?