I upload a couple of files to ilustrate the problem and help to understand my explanation.
I have a data source made by Excel files (one for year since 2012), each file has one sheet for every month, each sheet has several tables which share some headers as u can see in attached file ("Tables Relantionship.png").
Tables are delimited by an indeterminated number of columns, also every table could have a different number of columns from one sheet/file to other, one example of this are on attached file ("Example.png").
I have to make an scripting algorithm to automate the load of balance and P&L tables from every sheet from every file from the past and some which will come in the future. All balance tables must to be in only one table, and same with P&L tables.
But hese tables haven't got the format what I need, so I need to transpose them looking for these schema:
Epigrahp ------- Bank Code -------- Bank Name ------- Date --------- Quantity
I attached my code ("PruebaExcel.qvw"), but it doesn't work. Im using neutral header (@) to be able to load the changing number of fields of every table but when I try to concatenate inside of loops diferent tables of the same type dont work because they have different number of fields.
Hope now you have more information to understand and can help me.
Thanks in advice and Regards. Nahúm.