Coalesce on 3 different field in Transform maps

[Suvetha S]

Hi all,

We are importing data into cmdb hardware table through transform maps. We want the coalesce field to be set on 3 different fields. Serial Number, Name & IP address. If serial number is  empty, it should look for Name, if Name is empty it should look for IP Address. Please help with the script. 

[Suvetha S]

No No. I want insert action too. The source records should first look for Serial Number, if a matching serial number is found it should update the record, if its empty or no such record it should look for the name, if it is empty/no matching records , it should look for the IP address. If all the 3 fields are empty/no matching records, then it should do an insert in the target table