5 Replies Latest reply: Jun 28, 2016 6:04 AM by Jerry Svensson RSS

    No table is created

    Mindaugas Bacius

      I have a script.

      Unfortunately, I cannot figure out what is wrong because map_Tour is an empty table. Actually there is no table after reload.

       

      tmp:
      LOAD SY103_WOCHENTAG, 
           SY103_TOUR_NR
      FROM
      Source
      (qvd);
      
      tmp2:
      CrossTable(Day, Tour)
      LOAD ID, 
           [1], 
           [2], 
           [3], 
           [4], 
           [5], 
           [6], 
           [7]
      FROM
      Source
      (ooxml, embedded labels, table is Points);
      
      Concatenate (tmp)
      load distinct ID & '|' & Day as SY103_WOCHENTAG
        ,Tour as SY103_TOUR_NR
      Resident tmp2
      where not(Exists(SY103_WOCHENTAG, ID & '|' & Day))
      ;
      
      DROP Table tmp2;
      
      map_Tour:
      Load *
      Resident tmp;
      
      DROP Table tmp;
      

       

      When I add any new field in map_Tour I get the table:

      map_Tour:
      Load *
           ,1
      Resident tmp;
      

       

       

      But I would like to understand the reasons why the script without any additional field in the map_Tour do not work.

       

      Thank you!