I have a query that extracts transactions from a PDF that has multiple pages. My data is on page 2 and 3 but the transform definition for page 2 does not work for page 3 so I have written, in the file, a query for page 3. Don't know why page 2 query doesn't work for page 3, the PDFs look the same and I am grabbing the same data, but the column count varies.
I get the data from page 2 into spreadsheet.
In an ideal world I would like to output the page 3 query to the bottom of the page 2 query. I cannot work out how to do this.
I would settle for outputting into separate sheets but can't work out how to do this either.
Can someone offer some guidance please
I get the data from page 2 into spreadsheet.
In an ideal world I would like to output the page 3 query to the bottom of the page 2 query. I cannot work out how to do this.
I would settle for outputting into separate sheets but can't work out how to do this either.
Can someone offer some guidance please