Mathematical Addition in Azure Data Factory between 2 variables

Question

Hi All;

I am trying to add 2 numbers i.e. addition of Rows Read by 2 activity and trying to place that values inside a variable. But when I am trying to do this using add() function it is somehow not happening.
My Variable Source_Count is going to have below value:

add(@{activity('Copy_data_1').output.rowsRead},@{activity('Copy_data_2').output.rowsRead})

I tried with String property as well but ultimately output is coming like add(Number1,Number2) but the added value is not showing

add(@{string(activity('Copy_data_1').output.rowsRead)},@{string(activity('Copy_data_2').output.rowsRead)})

Answer 1

Hi @Abhijit Ghosh ,

Convert the values to integer and then pass on to the add function as below.

@ hide (add(int(activity('Copy_data_1').output.rowsRead),int(activity('Copy_data_2').output.rowsRead)))

Try the above and let us know please.

Thanks.