Using Split() in Additional Column $$column of Copy activity

Question

Using a copy activity, getting Column A from Source,
How do I use additional Columns in Source to Split() Column A into 2?
Is it even possible to use functions() on an incoming Source column ?
Can this be done without going into dataflows just with activities

Answer 1

Hi @nsh-2120,

No, we cannot derive a new column based on the source columns in additional columns space. We need to use data flow for such cases.

Please note that, in Additional Columns, we can use dynamic expressions that are based on variables, parameters and functions. But not on other columns.

Hope it helps.

Thanks