I have created a Data Script with two different tables and a unique key. When I create a straight table I can see all fields in the properties but cannot report across the tables - i.e. I get all data from Table 1 and blank results for the fields from Table 2.
In the original file, the fields are complete but when I try and report on them the second table data fields are either empty or I get two rows of independent data (one for each table)...In the eg. below, "Customer" is the "key".
well, in fact the key is a synthetic one (which should be avoided for performance reasons but nevertheless works) and not just "Customer" but "Customer" and "Country". I could imagine that you have Customer AND Country fields in both tables, but in ONE of them only Customer is filled (and country perhaps is NULL). Try to add the field "Country" to the table so you se what really IS being joined. Perhaps that helps.
Have tried it [as well as a left join - finally got the handle on that one] and get some better results but still not 100%. Have got an expert coming in on Monday to fix this for me so will see.
