5 Replies Latest reply: Nov 18, 2015 3:54 AM by Emelina Maluleke RSS

    Data not linking properly


      Hi. I have concatenated a table to another see the example below of the two tables. My problem is that the data does not link properly as the field that i want to see is created with null values (my expression is sum(Scores) labelled as score. What should be used to join the two tables

       

       

      Data:

      LOAD

      FileDate,

      Code1,
      Distinct [Code1] &'|'& date(Monthend(FileDate),'DD/MM/YYYY') as KEY%%,
      Code2,

      xxxx

      xxxx

      xxxx
      From.......................... 

       

       

      Score:

      NoConcatenate
      LOAD
      Code1

      FileDate,
      ScoreFields

      FROM
      xxxxxxxxxxxxxxxxxxxxxxxxxxxx

       

      Concatenate (Data)
      Score_Final:
      Load *,
      Distinct[Code1] &'|'& date(Monthend(FileDate),'DD/MM/YYYY') as KEY%%
      Resident Score;
      Drop table Score;

       

       

      Centre CodeNumberCode2 Code1NAME Months1Months2 DescrptionScoreTotal      
      36360020653999888999888Jukes L3415Undercover01 725 190
      ---999888Jukes L---1000