Setting a relationship

[traceystone]

Hello. Not sure exactly how to accomplish this in Alteryx. I have a set of Financial data which compares Forecast to Actuals. Data is maintained at an account level. Trying to create a significant supplier forecast to compare to actuals. I need to understand how to set up a relationship between Supplier Name/Customer Name and Supplier_Name_forecast columns to pull actuals for that supplier from the financials which are tied to the supplier name/customer name field.. Here is an example of my dataset. Ideas? 

Period Name	Forecast / Actual	HFM Account	Forecast	Total Spend	Supplier Name/Customer Name	Supplier_Name_Forecast
Jan-22	Actual	A660000-Expense		500	Company ABC
Feb-22	Actual	A660000-Expense		500	Company ABC
Mar-22	Actual	A660000-Expense		500	Company ABC
Apr-22	Actual	A660000-Expense		500	Company ABC
May-22	Actual	A660000-Expense		500	Company ABC
Jun-22	Actual	A660000-Expense		500	Company ABC
Jul-22	Actual	A660000-Expense		500	Company ABC
Aug-22	Actual	A660000-Expense		500	Company ABC
Sep-22	Actual	A660000-Expense		500	Company ABC
Oct-22	Actual	A660000-Expense		500	Company ABC
Nov-22	Actual	A660000-Expense		500	Company ABC
Dec-22	Actual	A660000-Expense		500	Company ABC
Jan-22	0+12 Sup	A660000-Expense	200			Company ABC
Feb-22	0+12 Sup	A660000-Expense	200			Company ABC
Mar-22	0+12 Sup	A660000-Expense	200			Company ABC
Apr-22	0+12 Sup	A660000-Expense	200			Company ABC
May-22	0+12 Sup	A660000-Expense	200			Company ABC
Jun-22	0+12 Sup	A660000-Expense	200			Company ABC
Jul-22	0+12 Sup	A660000-Expense	200			Company ABC
Aug-22	0+12 Sup	A660000-Expense	200			Company ABC
Sep-22	0+12 Sup	A660000-Expense	200			Company ABC
Oct-22	0+12 Sup	A660000-Expense	200			Company ABC
Nov-22	0+12 Sup	A660000-Expense	200			Company ABC
Dec-22	0+12 Sup	A660000-Expense	200			Company ABC

[DataNath]

Hey @traceystone, not sure if I've read into this wrong but do you need them side by side for comparison? If so, I've split the data off into two streams based on actual and 0+12 sup then re-joined them and only kept non-duplicate fields:

[traceystone]

Hello.. Not really. I am not sure I am using the right Alteryx lingo. :) When I am looking at 0+12 Sup forecast I can't pull the actual apend because they are tied to supplier name/customer name field. If I could somehow say supplier_name_forecast = supplier name/customer name that would allow me to pull supplier actuals against the supplier forecast. 

[DataNath]

@traceystone in the example above, when I have conducted the self-join, the conditions are that the periods and HFM account are the same, and that supplier name/customer name = supplier_name_forecast. What needs to change there? As this now brings the two values together in each record.