AnsweredAssumed Answered

How to handle empty rows in data pool

Question asked by shivanikaul on Feb 7, 2017
Latest reply on Feb 8, 2017 by Sameer_Chandragiri

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.

Outcomes