I have two tables in separate QVD files. However, when I load them into my script and do a Left Keep to link the tables, some of the data from the right table is not being shown. It is inconsistent as it shows some of the data as I want it to be. I actually checked the raw data files to see if there was any spacing and there isn't any.
That's what Left Keep does. It removes any records in the right side table that don't have matching records in the left side table. If you don't want that to happen, but want to keep all the data of the right side table then don't use Left Keep. Just leave it out and your tables will be linked without removing data.