I have'n' records and each of them has 11 fields that have reference to a txt file, in addition to other fields x of the same record, example:
As you can see the reference would be something like des_80_numero.txt , what I'm doing now is comparing this name with an absolute path of my local computer in which I have my txt with some data, in pentaho dump the data in a Script Values and all good and ok.
What is the problem? will ask , Well as a record has 11 fields that have reference to a txt file I have to read the 11 fields before I can dump them to an excel or insert them to the BD, but to be able to voor them I need to get the information from the 11 files and then I would have to make a kind of union in a single row to insert my data.
I currently do something with a Join rows (Cartesian Product) but it only helps me get 2 records, if I try to get more records the join rows multiply n times making the process slow and time consuming.
