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. | Description | Quantity | Unit Cost | Location Code |
ALHBT49006F1 | Chair 4 leg base | 5 | 1,000 | Brazil |
ALHBT47020F1 | Chair 4 leg base | 10 | 1,000 | Brazil |
ALHBT42003F1 | Chair 4 leg base | 15 | 1,000 | Brazil |
Attribute Data
Item No. | Option | Finish |
ALHBT49006F1 | Base Finish | 9006 silver |
ALHBT49006F1 | Base Type | 4 leg base |
ALHBT49006F1 | Standard Type | Standard |
ALHBT47020F1 | Base Finish | 7020 grey |
ALHBT47020F1 | Base Type | 4 leg base |
ALHBT47020F1 | Standard Type | Non Standard |
ALHBT42003F1 | Base Finish | 2003 orange |
ALHBT42003F1 | Base Type | 4 leg base |
ALHBT42003F1 | Standard Type | Standard |
This is what I would like to achieve:
Item No. | Description | Quantity | Unit Cost | Location Code | Base Finish | Base Type | Standard Type |
ALHBT49006F1 | Chair 4 leg base | 5 | 1,000 | Brazil | 9006 silver | 4 leg base | Standard |
ALHBT47020F1 | Chair 4 leg base | 10 | 1,000 | Brazil | 7020 grey | 4 leg base | Non Standard |
ALHBT42003F1 | Chair 4 leg base | 15 | 1,000 | Brazil | 2003 orange | 4 leg base | Standard |
Any help on this is much appreciated!
Thank you
Solved! Go to Solution.
Joseph,
Thank you so much, that was exactly what I was needing!