HOW TO LOAD DATA FROM QVD FILES TO GOOGLE SHEETS

[Achiever2023]

I have source records from Qlik saved as QVD files.

I also have google sheets which is used as a backend DB

What can i do to extract/load/export data from those QVD files to Google Sheets without lost of records.

Also each time a new records is saved into the QVD files, it should also automatically load the updates into the google sheets

[chutyas5]

I think I would just create the Status field and its values (PASS/FAIL) in the loop itself. On the how, there are probably countless ways to do this depending on how you set up your loop, but it could be a simple IF statement or using a variable which you update every time you go to next iteration of the loop.