Hi @OlaN ,

   Thank you for the reply. Actually the data needs to be inserted into same table i.e., Hardware table. Creating two transform map may not be good option for this because the data may not be present in all the columns. If it is present then i need to create another record if the data is not present in column or column B i just need to update the device type and update few other fields. Please let me know if the solution you suggested still works for this requirement?

Thanks!!