9 Replies Latest reply: May 27, 2012 6:06 AM by zubairaslam RSS

    JOIN and CONCATENATE, getting rid of empty values



      I have two tables, T1: A, B, C, D, E and T2: A, F

      When I use LOAD normally and add a F table I get all the values of F, what I want to do is to only include the F-values which A value is present in T1. So F-values which A-values isn't included in T1 should be excluded.

      I guess this is a INNER JOIN but I can't get it to work.

      How do I rewrite my load-statement to only include my desired values?

      Or is there a way in the listbox properties to write an expression to exclude certain values?