unpivot while reloading

[amien]

is this possible.. this datasource has this data structure:

LOAD FileNumber,Phone1,Phone2,Phone3

FROM...

but i need the data loaded like this:

Filenumber, Phone1

Filenumber, Phone2

Filenumber, Phone 3

etc.. etc

Thanks in advanced

[#2]

hi

ofcourse you can load data like this

Table1:

load filenumber, phone1 from ........;

Table2:

load filenumber, phone2 from ........;

Table3:

load filenumber, phone3 from ........;

this would result in 3 tables

regards

Peter