I have a scenario with 2 data pools. (Data Pool 1 & Data Pool 2).
Data Pool 1 is publishing data to target (table 1) using select queries and Data Pool 2 is marking a reference to the target table (table 1 ) and publishing the data to a file.
The publish for data pool 2 is failing when an empty row is found in target table (table 1) which was published from
data pool 1.
We have tried multiple ways to not publish empty row to target but we are not able to find a value to compare with when the query doesn't return any value in data pool.
could you please suggest some way to fix it.