If the contents of a column in the data match a certain condition, copy the same row data and add it to the same table.

Question

I would like to dividing a Annual Sales Amount to rows by month.
So if the word "Annual" be in a column , I would like to copy the low 12 times (some times 24 times but it is next step)
I thougt that could do that by "ADF AlterRow Insert Row", but could not that with AlterRow method.

How can I divid a row under a same condition?

Answer 1

Unfortunately,the transformations don't include a straightforward way to duplicate rows in a dataset based on a specific condition. You would usually handle such a transformation in the source query (if dealing with a database) or use a compute service like Azure HDInsight or Azure Synapse.

If you're working with a SQL-based source, you could write a query that performs this transformation at the query level. This could involve using a Common Table Expression (CTE) or a combination of UNION ALL statements.