hope that someone can help me with this problem.
on a monthly basis I receive 9 files , the structure of the XLSX file is the same but the headers are in different languages
in Dutch (4) and French ( 5 )
I store them in the same folder. But how do I solve the problem with the headers ?
headers are in row starting with criées for french and veiling for dutch
and how do I handle the block in the first 5 rows ( marked in brown )
is this a additional query on the same xlsx table?
In PBI the usual answer - it depends what are you try to achieve
Attach you can find PBI for FR transformation
and based on that also for NL transformation
I need to change Excel name, sheet name
and transformation about what is In and what is out transaction so it can be concatenated in Column name but rest is very similar.
I use original query (from xlsx) - and 2 references on top of that (one for first 4 rows and one for rest).
Thank you very much for your answer.
That is the easy part, the hard part is to make it a workable pbix with all the 9 files merged together and analyze where the food is coming from( in ) and what is the destination ( out )
and make a reports respecting the two languages. ( we are in Belgium after all !?)
See the screen shot below? Just one of the tables
I found the link to another site which offered me the solution of the headers
thanks for all the tips.
the link below for whom is interested in the solution
