dataflow - join

Question

in dataflow I am using join activity to join two tables. table1, table2

both tables have ID column and this is what I join them with.
both tables have a field called companyName.
in join, either table1.companyName has avalue or table2.companyName has a value
They will not both have a value in companyName.
I would like to select the companyName as a field and have the value from the tablefield which has a value.
for example my select is something like:

ID table1.field1 companyName
1 rterte this value comes from either table1 or table2 depending which one of them has a value

Thank you

Answer 1

Hi @arkiboy,

You can try coalesce() function in the Dataflow. Thanks!

coalesce(table1.companyName, table2.companyName)