Power Query - Dynamically find table location from different pages

[sara121]

Hi Friends,

I have PDF files with the same structure but different contents. When I transform a PDF file, table 1 locates on Page 3. In the other PDF file, table 1 is located on Page 4.

Is there a way to dynamically locate the table from different pages?

Thanks lot!

 

[jdellasala]

Maybe. I had a problem where the table I needed was identified differently for no apparent reason. I overcame the problem by adding a column that counted the number of rows in the tables:

= Table.AddColumn(FilteredTablesOnly, "Rows", each Table.RowCount([Data]), type number)

Luckily the table I was looking for had a LOT more rows than the others, so the next step just filtered the table like this:

= Table.SelectRows(AddedRowsColumn, each [Rows] > 15)

That way, the only row left was the one I needed, and I could proceed from there.