Forum Discussion
Power Query - Try inner join if second table exists otherwise skip inner join step
Good morning Power Query experts,
I am looking for a way to inner join table A with table B based on the condition that table B exists.
How can I skip this inner join step if table B does not exist?
(My table B shows data of open orders which might not be existing at some dates, due to all orders being shipped.)
Many regards for your help.
Simon
The way PQ works is that a query needs to exist. The output of your query will be TableB. If you don't receive TableB, the result of your query should be a blank TableB.
You will need to write your query in that way only.
Hence, your query needs to say if no applicable data, then no output.
Now, if you query churns out a text called "no applicable data", then you query should say
if previous step = "no applicable data then TableA else your join statement
3 Replies
Use this conditional statememt
= if Table.IsEmpty(TableB) then TableA else your join statement
Hey Vijay, thank you for your fast reply and help.
Does this also work if table B does not exist at all?
If there currently are no open orders I do not even get a table at all instead I only get a line saying "no applicable data".
Many regards,
Simon
The way PQ works is that a query needs to exist. The output of your query will be TableB. If you don't receive TableB, the result of your query should be a blank TableB.
You will need to write your query in that way only.
Hence, your query needs to say if no applicable data, then no output.
Now, if you query churns out a text called "no applicable data", then you query should say
if previous step = "no applicable data then TableA else your join statement
