Normalizing table data

1

I am receiving a CSV file where one field (genericEquiv) has a bunch of comma separated values

part; qty; name; genericEquiv
7130648-383;	6	;RESISTOR, THIN FILM, CHIP, 40MW, 25V, +/- 0.1%, SMT, 0402; R332,R363,R420,R427,R589,R596

I would like to do a typical normalization by splitting that field by the commas into an :“array”: and then producing a normalized table like:

7130648-383;	6	;RESISTOR, THIN FILM, CHIP, 40MW, 25V, +/- 0.1%, SMT, 0402; R332
7130648-383;	6	;RESISTOR, THIN FILM, CHIP, 40MW, 25V, +/- 0.1%, SMT, 0402; R363
7130648-383;	6	;RESISTOR, THIN FILM, CHIP, 40MW, 25V, +/- 0.1%, SMT, 0402; R420

What transforms do I use so that I can duplicate the rows and loop through the split column attributes? so that I only have one Resistor type per row?

2

The “Split delimited column into rows” action does exactly that. Apply it to the last column (with R332,R363,R420,R427,R589,R596).