normalization - how to normalize the records? e.g. several similar columns into rows -

i using pentaho kettle , thinking on way normalize flat file (csv) data. store database.

csv structure: item name, store1 sold quantity, store2 sold quantity, store...

expected result: item name, store name, sold quantity

any guidance appreciated.

you can row normalizer step long number of stores fixed or @ least has maximum. if it's variable, you'll have use javascript step, or udjc. see docs how use these steps:

pdi transform steps

if it's variable, i'd consider preprocessing file before loading. i've done python , works pretty well.