Joins Issue

[Ultimo]

Hi

Issue:

I have two files The Hierarchy file (acts as a mapping doc) and PO report file. The PO file does not have column K (EB Member) and this is basically being looked up from the Hierarchy mapping file (similar one is in sheet 2).

The idea is to then output the data in the format in tab detailed and summary once the EB column is added (I have used Pivots for this in excel):

I have tried to use the join tool for this but because the common id is ESFS cost centre (hierarchy) and Cost centre id (PO report) the issue i have is the unique identifier in the PO report is the order ID and this doe not exist in the hierarchy so it is duplicating the results in some instance.

If i ca some how get to a workflow that joins this properly then i can play around to get the final output but would the community help me in getting to that point pls?

Thanks!

[mceleavey · Accepted solution]

Hi @Ultimo ,

Are you wanting the join to prevent duplicates on the cost centre ID key?

I have done this by grouping these keys on the hierarchy input in the sum tool:

This prevents duplication on the join:.

Hope this helps,

M.

[Ultimo]

@Mceleavey thanks so much for your help with this!