DWC Data Modeling Query

[former_member629064]

We have a column with comma-separated values. The task is to break that column based on coma and map values from other tables. Again create a new column in original which is having mapped values as comma-separated

Attaching a screenshot of the input table and expected table.

Input Table

Expected Table:

[IngoH]

Hello Vikas,

as part of the upcoming Data Flow feature, which is being released in Q4 2020, you will also have the option to use python as part of your transformation. perhaps that allows you to do then what you are looking for.

Regards

Ingo Hilgefort, SAP