Hello,
Hopefully this is an easy question. I am trying to populate a column within my workflow based on data from my input file. The column I need populated is called “Master Industry” and there are 2 criteria that determine which column of information (in my data set) is what needs to be populated.
Where the RFI Code (column E) is “F” then I need the “Shipper” (column F) to populate as the Master Industry (column D). (If I were doing this manually in excel, I would simply copy the content of column F into column D for that row.)
Where the RFI code is “R” I need the “Care Of” to populate as the Master Industry if there is a value within this field. If there is no value within the “Care Of” field then I need the “Consignee” (Column H) to populate as the Master Industry.
In my mind, there should be a way to do this within the formula tool, but I haven’t been able to determine the exact statement to get this to work.
Hopefully below communicates what I am thinking.
Attached is my Alteryx workflow and my input data file. Below shows the Alteryx tools I am trying to utilize in this simple test.
Below shows my input data.
Below shows my desired output.
Thanks in advance!
