This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am creating a workflow with an Output Column in which this Output Column will be used to group and summarize the data in the workflow. I just added a TEXT INPUT to use as a VLOOKUP table that JOINs into the workflow to populate more fields in the Output Column.
Is there a way that the outflow in the JOIN (J) can populate the Output Column? What is happening is my outflow JOIN (L) data is in the original Output Column, but the outflow JOIN (J) data is in a new Output Column.
I attached a sample of the data after I cleansed for privacy issues. Inflow (L) JOIN tab, the highlighted column is what I am trying to recreate with OpCom View 1. Inflow (R) JOIN is the VLOOKUP table that is populating more of the null cells in Inflow (L) JOIN.
The map tab is just a visual representation of what I am trying to do.
Outflow JOIN (L), OpCom View 1 is data I want and Outflow JOIN (J) OpCom View 2 is data I want, just want them in the same column.
@dgcolby In essence, are you trying to create a new column with the same OPCOM VIEW column data? If that's not the case, I know you have the vlookup table (Inflow (R) Join) but what is the dataset you are trying to join into?
I know you want the Outflow JOIN (L) and Outflow Join (J) as a result.