Hi everyone !
I have a problem with a very simple Query that I'v made using PowerQuery. Let me explain the Query...
- I import a PDF file that contains normally 6 columns, one columns contains the name of the account while the 5 others contains financial data for the last 5 fiscal year.
- When I refresh the data with another PDF file that contains 5 fiscal years, I do not have any problem, my Query works perfectly.
- You see me coming ? My problem is when my a refresh the data with a PDF file that contains less than 5 fiscal years, I got an error message that I missed column #6.
Anybody could help me to resolve that issue please ?
Thanks a lot and wonderful day to you !
Francis
I have a problem with a very simple Query that I'v made using PowerQuery. Let me explain the Query...
- I import a PDF file that contains normally 6 columns, one columns contains the name of the account while the 5 others contains financial data for the last 5 fiscal year.
- When I refresh the data with another PDF file that contains 5 fiscal years, I do not have any problem, my Query works perfectly.
- You see me coming ? My problem is when my a refresh the data with a PDF file that contains less than 5 fiscal years, I got an error message that I missed column #6.
Anybody could help me to resolve that issue please ?
Thanks a lot and wonderful day to you !
Francis