How to concatenate multiple rows

Anjankumar2021

Hi All,

could someone pls assist on the below issue?

Input:

Table-A

Name	Date
A	28/08/2024
B	28/08/2024
C	28/08/2024
A	28/08/2024

Table-B
Name	Product	%
A	MSBI	100
A	Alteryx	100
A	Java	99
A	Net	55
A	MSBI	100
B	Java	100
B	Net	85
B	MSBI	65
C	Net	100
C	Net	100
C	Net	100

Required output: In Table B will concatenate products if we have multiple product with 100 % for unique Name(A- MSBI/Alteryx@100). i need unique Product with 100( Product@100) in comment column in Table A .

will ignore if product percentage is less than 100

Name	Date	COMMENT
A	28/08/2024	MSBI/Alteryx@100
B	28/08/2024	Java@100
C	28/08/2024	Net@100
A	28/08/2024	MSBI/Alteryx@100

Workflow

Accepted answers

Qiu

@Anjankumar2021
A quick sample similar with @KGT approach and add one Record Tool to maintain the order at the end.

0828-Anjankumar2021.yxmd

All comments

KGT

Summarize tool will achieve this grouping on Name & Percentage, concatenate on Product.

Then filter for percentage = 100. You may need to use a formula then to get your exact format of the comment column

Qiu

@Anjankumar2021
A quick sample similar with @KGT approach and add one Record Tool to maintain the order at the end.

0828-Anjankumar2021.yxmd

NeoInfiniTech

Hello @Anjankumar2021,

I prepared two different solutions in the workflow attached.

One ignores the repeating row with same date for A (28/08/2024) and outputs 3 rows, while the other also takes into account the repeating row and outputs 4 rows.

If the 4th row for the date table was "A | 29/08/2024" for example, both containers would output 4 rows.

Record Generation.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280