Join Tool Support

[pbresney]

I need support joining data within my flow. In one sheet, I have a list of codes, and in the other sheet, I have a list of descriptions associated with each code. In the codes sheet, there are 3 columns, Code 1 Code 2 and Code 3. Sometimes there is only a code in code 1, sometimes in 1 and 2, and sometimes in 1,2, and 3. I need support with a flow that grabs the descriptions that are associated with each code and populates in a new sheet with all the data.

I want the output to be on the right, and have a "code 1 description" "code 2 description" "code 3 description" 

Any tips?

[aatalai]

connect the 2 data sources to a join tool and select code 1, code 2 and code 3 as joining criterias

Let me know how you get on

[pbresney]

Thank for the reply. When I attempted to do this in the past I did not get any inner join output. The inputs are coming from 2 sheets. 1 with the codes, and 1 with the total list of codes, and the next column is the corresponding description.

[aatalai]

ok check that the empty fields are actually empty and don't have trailing spaces etc as this can cause an issue, use a data cleanse to be extra sure

@pbresney hope this helps, if you upload some files/data that can be copied and pasted happy to take a look and mock something up

[pbresney]

Here is a sample of test data. Thank you!

[Raj]

@pbresney 

one way of achieving this.

[Raj]

@pbresney another way of doing this
mark done if solved.