Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.
How to retrieve the data from 2 different datasource and write it to a file
mdsheeraz
Posts: 25 ✭
in Virtualize
Hi,
We have a requirement to retrieve the Peak and PeakTime from db2 for the meter numbers retrieved from another db called db1.
there was already a logic to fetch all the active meters data for a day from db1 and write it to a file, now we need to append the values for Peak and PeakTime to the meters which need to identify as peaktype from the active meters of db1 and append retrieved values from db2 to the identified peaktype meters rows.
and keep Peak and PeakTime as Null for the meters which doesn't match with peaktype.
could anyone please help how to achieve this requirement.
attaching a groovy script file which has existing logic to write a file having Peak and PeakTime as null.
Tagged:
0