How to Flatten a semicolon Array properly in Azure Data Factory?

Context: I've a data flow that extracts data from SQL DB, when data comes is just one column with a string separated by tab, in order to manipulate the data properly, I've tried to separate every single column with its corresponding data:

Solution

You can use the derived column activity itself, try as below.

After the first derived column, what you have is a string array which can just be split again using derived schema modifier.

Where firstc represent the source column equivalent to your column descripcion

Column1: split(firstc, ';')[1]

Column2: split(firstc, ';')[2]

Column3: split(firstc, ';')[3]

Optionally you can select the columns you need to write to SQL sink