Good morning. I have two tables in my load script...Sales History and Item Master. I want to create a third table that takes the Item Number from Sales History and concatenates it with the Item Description from Item Master ultimatley resulting in a "Item Number Name" field. Can someone please recommend the best way to do this? All of this needs to be done in my load script. I would like to do this using Resident loads. Thanks.
