Hello Community,
I am recently in the process of transitioning data tables from SQL to a new environment. We have tasked Qlik with comparing record attribute accuracy from the source tables (SQL) to the new environment as they should be identical. I have started the process by creating QVDs for both sources and am now attempting to compare record counts, etc between the two. Does anyone have an idea as to how to accomplish this in a scaleable manner? I am attempting to identify any differences between the two. One thing to note, the new source capitalizes all field names, whereas the original source varies.
Appreciate any and all help.
Please let me know if the ask in unclear.
Thanks
TJ