Split single line entry into mutliple table entries using BODS.

[Former Member]

Hi All,

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?

Thanks,

Tim

[Former Member]

Hi Maurice,

Thanks for the reply. It's more based on a condition so say if column 1 has a value, then you get row 1 created, if column 2 has a value then only row 2 gets created. Also, the source table contains multiple columns and not all will be pivoted into rows, just a certain particular columns.

Anyway, i had resolved this at the moment via CASE to split single row input into individual Queries and MERGE them back creating multiple rows.

Would like to know if anyone has a better 'performance wise' solution.

[Former Member]

Tim

Have you looked at the Pivot transform? Ideal for transforming columns to rows for a fixed / known number of columns.