I have 2 tables with the join Table1.Substring (col1,1,4) = Table2.ID.
I am writing MID in the load statement for table 1 as: Load MID (col1,1,4) AS ID. Would this join work? Because I cannot see both table's data together. Either one of the tables data is displayed. One of the table shows blank data when other one displays data.
I changed the query little bit. I am now loading data from the qvd file instead if using select in the same tab. I can see the physical join in table viewer but The tables are not joined. The QVD file just has select statement and qvw file has query as below.