SKU with same name but different location

[thunderbolt012]

Hi All, 

Running into an issue where there is an Item(#) that is my main dimension and relationship but it can appear in 2 locations (BPs). Is there a way to have logic that matches Item# with a BP? unsure if merge or concatanate will work because the users do not want a combinded record.  

Example of issue: 

Data Set that is being fed into a larger set: 

the highlighed is the concate ID w/ the correct BP (column 2) as the last 2 digits. However, the relationships connect item (column 3). 

Any advice or assistance is greatly appreicated. 

[lbendlin]

Usually you handle these kinds of relationships in your data model.  What have you tried and where are you stuck?