Adjusting my query to changes in Source file

Question

Hello everyone,&nbsp;I need to extract data from a pdf table on a quarterly basis and this time Power Query reads out the heading in a Column 11 instead of Column 10.&nbsp; Is there any chance to get the first two rows back to column 10? The issue is that the following rows are in correct order. I would be pleased to get some tips on how to handle this.&nbsp;Screenshot of original pdf file&nbsp;&nbsp;&nbsp;Original Query&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;New Query&nbsp;&nbsp;

isjoycewang · Accepted Answer

Hi&nbsp;AVW1983&nbsp;,&nbsp;Demo file attached. Please try below steps:1. Add a new [Index] column&nbsp;2. Create new conditional columns based on [Index]&nbsp;3. Remove incorrect columns and [Index]&nbsp;Best Regards,Joyce

Forum Discussion

Adjusting my query to changes in Source file

2 Replies

Related content

Changing Data Source

Data Source Credentials Password Change

Data source Schema changed

Change Source Connection on Mirrored Database

How to change data sources