Background: Dataset has record_id that will define whether to follow approach1 or approach2 in workflow.
its possbile dataset can have record_id for both the approaches or either of them.
dataset --> check record_id --> If 1 then follow approach 1 --> output 1 --> merge both the output using Union (this is final output)
check record_id --> If 2 then follow approach 2 --> output 2
Problem: when the dataset contains record for any one ; union fails starting NO common records found.
it works fine when dataset has record for both.
Dataset:
| check record_id | Colum1 | Colum2 | Colum3 |
| 1 | test1 | Address1 | State1 |
| 1 | test2 | Address2 | State2 |
| 2 | test3 | Address3 | State3 |
Approach:
used summarize tool to get count ;
then filter tool to check whether count >=1
if true follow approach 1 --> business logic --> output1 --> Merging both to get the final output (it fails depending upon intial dataset)
if false follow approach 2 --> business logic --> output2
