Concatenate multiple values with the same field and with the same ROWID

[Former Member]

How can I concatenate multiple values into one one error_message based on ROWID or with same ROWID? Thanks. Please see attached file for sample data.

[former_member187605 · Accepted solution]

If you know the maximum number of values in advance ,do as in Solution required for one ETL scenario in BODS | SCN.

If not, create a custom function as in

[Former Member · Accepted solution]

Thank you very much. It helps a lot. More power.

[former_member208402]

Hi Prince,

Please use this below scenario to get the desired output.

https://dwbi.org/etl/sap-data-services/99-data-services-scenario-questions-part-6

https://dwbi.org/etl/sap-data-services/100-data-services-scenario-questions-part-7

Thanks,

Ravi kiran.

[Former Member]

Thank you very much. It helps a lot. More power.