Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Combine rows based on *

ZahinOsman
8 - Asteroid
‎12-03-2023 10:14 PM

Hi all,

 

I have 2 excel tables in 2 different sheets;

 

Table A

Trade IDBook_NmBook CDSap Company CDCountry CDCountry NmTrade MnthDate.Period 
1234BearGumbo5279SGSingapore2023-033/8/2022*
1234AppleGumbo5279SGSingapore2023-033/8/2022 
1234SolidGumbo5279SGSingapore2023-033/8/2022*
1234DoneGumbo5279SGSingapore2023-033/8/2022 

 

 

Table B

Trade IDBook_NmBook CDSap Company CDCountry CDCountry NmTrade MnthDate.Period
1234567CheeseMama5279SGSingapore2023-033/8/2022
1234567CheeseMama6790SGSingapore2023-033/8/2022
1234567CheeseMama5279SGSingapore2023-033/8/2022
1234567CheeseMama6790SGSingapore2023-033/8/2022
57823BriePapa5670SGSingapore2023-033/8/2022

 

 

How do I combine the rows marked with * with table B? It should look like something below to form Table C;

 

Table C

Trade IDBook_NmBook CDSap Company CDCountry CDCountry NmTrade MnthDate.Period
1234567CheeseMama5279SGSingapore2023-033/8/2022
1234567CheeseMama6790SGSingapore2023-033/8/2022
1234567CheeseMama5279SGSingapore2023-033/8/2022
1234567CheeseMama6790SGSingapore2023-033/8/2022
57823BriePapa5670SGSingapore2023-033/8/2022
1234BearGumbo5279SGSingapore2023-033/8/2022
1234SolidGumbo5279SGSingapore2023-033/8/2022

 

Appreciate the help!

 

 

 

Labels:
Reply
0 Likes
1 REPLY 1
Hammad_Rashid
11 - Bolide
‎12-03-2023 10:31 PM
 

Capture.PNG

 

  1. Load Data

  2. Filter Rows in Table A:

    • Use the Filter tool to filter the rows in Table A where the condition is met (the rows marked with *).

  3. Union:

    • Use the Union tool to combine the filtered rows from Table A with Table B. Connect the output of the Filter tool to one input of the Union tool and Table B to the other input.

  4. Output

New Workflow1.yxmd
Reply
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All