Quote Originally Posted by PAVB View Post
Logic is not clear to me but assuming is something like building rows taking specific columns from different text file lines I would suggest to define the text file as an "external table" then write a query that does what is needed.
PAVB your right, make it a external table it should come out the best