if i convert “.pdf” to text & use get data from “.txt” or “.csv” file & set file origin on “1256:Arabic (windows)”, then i have a correct text in PQ.

I’m a newbie in Excel Power queries (M) and would appreciate some assistance. I have a table with the structure below. I would like to populate a column called “Daily Wage”, which is = “3 month Salary” divided by 90 (days in 3 months). The difficulty is that:

I have a web query which is expensive (time consuming) to run and I wish to return multiple processed tables (e.g. 3 tables) within the same query, and display the results to separate sheets?

I’m running a query which returns a record with a number of fields.
If the record contains the field ‘CashField’, the query continues as normal. However, if the field does NOT exist, is there a way to terminate the query cleanly and exit the function i.e. not subsequent steps from running?

I’m a newbie to Excel Power Queries (M language) and would appreciate some help. I have a table with a list of records called ‘repTbl’. I wish to extract the contents of each record (2 records in the example below), and combine them into a single table.