About EasyMorph Tutorials & Examples Web-help

Normalizing table data

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?

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

To learn more about EasyMorph visit easymorph.com.