Join two data tables when in table 1 there are repeated records

Help Activities
, ,
1

my table 1 is this

Código del material (cliente) Quantity
L2236700 500
L99362B0 100
L99362B0 100

my table two is this

# Cliente SAP Clave SAP Código del material (cliente) MOQ
100000 70011 L2236700 50000
100000 70625 L99362B0 166320

and what I get when joining by the “Código del material (cliente)” column is tihis

Código del material (cliente) Quantity # Cliente SAP Clave SAP MOQ
L2236700 500 100000 70011 50000
L99362B0 100 100000 70625 166320
L99362B0 100

as you can see if I reconcile with the join datatable command but the record L99362B0
is repeated twice, the second leaves it blank and that does the same as if it repeats more than twice, how can I make a DT1 and DT2 if there is going to be repeated data in DT1

I should go out like this

Código del material (cliente) Quantity # Cliente SAP Clave SAP MOQ
L2236700 500 100000 70011 50000
L99362B0 100 100000 70625 166320
L99362B0 100 100000 70625 166320

thanks

2

@Ivan_torres_oliva

Check below output for your reference

image

Here is the workflow
JointheValues.xaml (17.3 KB)

Mark as solution if this helps you

Thanks