Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Multiple tables mapping

Highlighted
6 - Meteoroid

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)

MandyL_0-1575541483141.png

 

Value Table (Table 2)

MandyL_1-1575541483146.png

 

Output:

MandyL_2-1575541483148.png

8 - Asteroid

Hi @MandyL ,

Attached is the closest I could get.

 

Mark this as a solution if this resolves the problem.

 

Regards!

TD

Labels