Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiple tables mapping

MandyL
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

1 REPLY 1
TarunDeep
8 - Asteroid

Hi @MandyL ,

Attached is the closest I could get.

 

Mark this as a solution if this resolves the problem.

 

Regards!

TD

Labels