Forum Discussion
Check table exists before combine
It looks like your Query1 doesn't result in a list of Tables, like in the following example:
Thank you, that pointed me in the right direction to solve what I needed.
What I ended up with was the below, which trys each table and if no error puts in the table name otherwise adds a blank. Then when I use the table list in my combine query I filter out the blank table names first.
Probaly not the best way but it works for me.
let
value1 = if (try UKAHL)[HasError] =true then "" else UKAHL,
value2 = if (try UKJR)[HasError] =true then "" else UKJR,
value3 = if (try NLJR)[HasError] =true then "" else NLJR,
value4 = if (try ITBVG)[HasError] =true then "" else ITBVG,
value5 = if (try ITAHL)[HasError] =true then "" else ITAHL,
value6 = if (try IEJR)[HasError] =true then "" else IEJR,
value7 = if (try IEAHL)[HasError] =true then "" else IEAHL,
value8 = if (try FRBVG)[HasError] =true then "" else FRBVG,
value9 = if (try ESBVG)[HasError] =true then "" else ESBVG,
value10 = if (try DEBVG)[HasError] =true then "" else DEBVG,
value11 = if (try DEBVG1)[HasError] =true then "" else DEBVG1,
value12 = if (try DEAHL)[HasError] =true then "" else DEAHL,
value13 = if (try BEJR)[HasError] =true then "" else BEJR,
Table1 =#table(1,{{value1}}),Table2 =#table(1,{{value2}}), Table3=#table(1,{{value3}}),Table4 =#table(1,{{value4}}),Table5=#table(1,{{value5}}),Table6 =#table(1,{{value6}}),Table7 =#table(1,{{value7}}),Table8 =#table(1,{{value8}}),Table9 =#table(1,{{value9}}),Table10 =#table(1,{{value10}}),Table11 =#table(1,{{value11}}), Table12 =#table(1,{{value12}}), Table13 =#table(1,{{value13}}),
Tablelist = {Table1,Table2,Table3,Table4,Table5,Table6,Table7,Table8,Table9,Table10,Table11,Table12,Table13}
in
Tablelist
Possibly code like the following - shortened - example will also work for you?
let
TableList =
{try UKJR otherwise #table(1,{}),
try ITBVG otherwise #table(1,{})}
in
TableList