My Primary source is "data_1.xls" that contains a list of all my servers. I need additional fields that I get from a very large source "data_2.xls" (the attached is just a sample the real files contains thousand of rows) by doing a LEFT JOIN. So far so good, see attached qvw.
The problem is that not all the Servers that are in data_1.xls are in data_2.xls. Therefore I need to load an additional file with this missing data "data_3.xls" to fill in the blank rows. How do I do this?