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

Adding multiple rows from different data source into new columns

stu_adz
5 - Atom

Hi there,

 

I am completely new to Alteryx and have tried searching for this but have not really known how to describe it or what this general function is called.

 

I have two separate data sources that are linked by the "Item No." field.

 

I would like to pull the Attribute Data into the Sales Line data.

 

This is what I have currently:

 

Sales Line Data

Item No.DescriptionQuantityUnit CostLocation Code
ALHBT49006F1Chair 4 leg base51,000Brazil
ALHBT47020F1Chair 4 leg base101,000Brazil
ALHBT42003F1Chair 4 leg base151,000Brazil

 

Attribute Data

Item No.OptionFinish
ALHBT49006F1Base Finish9006 silver
ALHBT49006F1

Base Type

4 leg base
ALHBT49006F1Standard TypeStandard
ALHBT47020F1Base Finish7020 grey
ALHBT47020F1Base Type4 leg base
ALHBT47020F1Standard TypeNon Standard
ALHBT42003F1Base Finish2003 orange
ALHBT42003F1Base Type4 leg base
ALHBT42003F1Standard TypeStandard

 

This is what I would like to achieve:

Item No.DescriptionQuantityUnit CostLocation CodeBase FinishBase TypeStandard Type
ALHBT49006F1Chair 4 leg base51,000Brazil9006 silver4 leg baseStandard
ALHBT47020F1Chair 4 leg base101,000Brazil7020 grey4 leg baseNon Standard
ALHBT42003F1Chair 4 leg base151,000Brazil2003 orange4 leg baseStandard

 

Any help on this is much appreciated!

 

Thank you

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @stu_adz I mocked up a workflow that produces your output. Let me know what you think?

 

Crosstab_Join_060802020.JPG

stu_adz
5 - Atom

Joseph,

 

Thank you so much, that was exactly what I was needing!

 

 

Labels