Power query failures for added/removed columns

[rjmdc]

hi
my table comes form the government
they add or remove columns depending on the fiscal year or renewal date
i dont want to do a remve other coluns as when they add a column i need it in my calculations
how do i accomodat to accepth the table the way it is with added/removed columns and still get the results i need or is it impossible?

 

[alansidman]

Your explanation is too vague to respond to other than to ask for sample data of what you have and what you want. Please use XL2BB.

 

[rjmdc]

hi
it is HIPAA protected
however question is like this
Jan through may and Aug through Dec always 5 columns: f. name, l. name, auth #, date, org
June and July they add column Reauth , i want my process to work regardless
i connect to a folder
process : it takes last document always refreshes and reviews the process and reads auth number
every June it fails as it doesn't recognize the last new column
i actually need that columns data in June and July

 

[alansidman]

I understand about HIPAA protection. Post some dummy info. 8-10 anonymous records and then mock up your solution. We need to understand your structure and the expected results that you can then apply to your actual file.

 

[rjmdc]

I created a brand new book that retreives only the datasheets that have the extra colum i needed this project asap
over the day i will craete a dummy and upload