Skip to Content
0
Jun 03, 2020 at 09:09 AM

SQL SCRIPTING in Calculation View

123 Views Last edit Jun 03, 2020 at 09:10 AM 3 rev

Hello All,

I have the below Logic Already existing in a Calculation View:

Select A,B,C

from table 1

UNION

Select A,B,C

from table 2;

Now i want to convert the above logic to below scenario, in case if First select statement succeeds in fetching data then second Select statement data should not be considered. Only when there is no data at first Select statement we need fetch the data from second Select Statement.

Kindly help me with our inputs for this requirement.

Thanks in Advance!