Multiple tables mapping

[MandyL]

Hi,

I’m new to the Alteryx tool. Here is an example, there are two data sources. One is the type code table; each Type Code (row-column) has related type name and salesperson. The other is the value table, the Type Code shows on the top and row data shows the Type Name and related values.
I can create the summarize tables by each Type Code on the Value Table, and then create the Type Code filters to match the Type Name and then get the Sales Person.
The real database has 10+ Type Codes and 10,000+ Type Name. Is there any good way to reduce the workflow? Thanks!

Type Code Table (Table1)

Value Table (Table 2)

Output:

[TarunDeep · Accepted solution]

Hi @MandyL ,

Attached is the closest I could get.

Mark this as a solution if this resolves the problem.

Regards!

TD