Tricky Import Problem

[Ksquared]

I have column data whicn im trying to get in to data for each record.
The data is layed out like....
LOCATION, STOCKPILE, PAD, X1, X2, X3, X4
abc 123 x 2 1 0

Im trying to get the data into the database like this....

abc,123,x,2
abc,123,x,1
abc,123,x,0

...so for each of the X values i need to write the preceding info into the DB....

Any ideas will be greatly appreciated.

Cheers.
K2

 

[rasETL]

Ksquared

If the file always contains 7 columns, the fastest approach would be to load the file 3 times...

1st Pass - Columns 1,2,3,4,5
2nd Pass - Columns 1,2,3,4,6
3rd Pass - Columns 1,2,3,4,7

Hope that helps

 

[bertrandkis]

I have seen your post late, do you still need help about this?