Add data from table A to every data in table B
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I'm new to Alteryx, and I am trying to combine the attached Alteryx Input A table with the Alteryx Input B table. I've included a Desired Output Example for reference. Basically, I want to insert the "Capital Account Code" and "Percentage" from Alteryx Input A table to every "ItemCode" and every "Period" in Alteryx Input B table.
Thank you in advance for your help.
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Patel is correct in that the "append fields" tool would solve your issue. However, after looking at your data, it is a bit more complex. For one, there are some "Null" rows in Table B that will affect the number of "junk" rows that will be created. Also, your Table A has rows that are both for fund DK_GROUP and MHDM. A simple solution attached would be to Filter on each one and do them separately.
Most notably, you will want (you don't have to for your small test set) to set the "Warn/Error on Too Many records being Generated" flag on the "Append Fields" tool to Allow all appends, as your Table B may grow to more than 16 records.
Also, make sure to adjust the File location in your input tools.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ejin,
I believe this is what you're aiming to achieve:
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm not convinced the append field tool would work @caschecter and @bpatel as there are multiple tabs in @ejin's workbook, therefore you need to use a dynamic input tool to bring in all sheets of input B and join on "fund" field from input B and input A which creates a new row for each record in input A. Finally outputting using "take file / table name from field" as an excel file to output data back into its individual sheets.
Hope that makes sense!
Regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much for your help. This is exactly what I need.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the help!
