1 Reply Latest reply: Feb 12, 2018 12:46 AM by Karthik Selvaraj RSS

    Table1:

    xxxxx yyyyy

      Iam trying to load this data, but I am getting error, Can you please give me a suggestion, Any mistake in this Script::

       

      Table1:
      2
      LOAD *FROM INLINE [
      3
      4
      Resource, sector
      5
      6
      Janet P, Team1 
      7
      David J, Team2 
      8
      Peter N, Team1 
      9
      Sarah P, Team1 
      10
      Michael H, Team2 
      11
      12
      ];
      13
      14
      Table2:
      15
      16
      LOAD *FROM INLINE [
      17
      18
      19
      Resource, Salary, Sales
      20
      21
      Sarah P, £33,000, £150,000 
      22
      Donald T, £24,000, £147,000 
      23
      Janet P, £27,000, £72,000 
      24
      Walter M, £26,000, £107,000 
      25
      David J, £32,000, £96,000 
      26
      Peter N, £29,000, £47,000 
      27
      Donny G, £31,000, £112,000 
      28
      Michael H, £28,000, £137,000 
      29
      Trisha Y, £32,000, £92,000 
      30
      Derek A, £33,000, £63,000 
      31
      ];
      
      Table1:
      2
      LOAD *FROM INLINE [
      3
      4
      Resource, sector
      5
      6
      Janet P, Team1 
      7
      David J, Team2 
      8
      Peter N, Team1 
      9
      Sarah P, Team1 
      10
      Michael H, Team2 
      11
      12
      ];
      13
      14
      Table2:
      15
      16
      LOAD *FROM INLINE [
      17
      18
      19
      Resource, Salary, Sales
      20
      21
      Sarah P, £33,000, £150,000 
      22
      Donald T, £24,000, £147,000 
      23
      Janet P, £27,000, £72,000 
      24
      Walter M, £26,000, £107,000 
      25
      David J, £32,000, £96,000 
      26
      Peter N, £29,000, £47,000 
      27
      Donny G, £31,000, £112,000 
      28
      Michael H, £28,000, £137,000 
      29
      Trisha Y, £32,000, £92,000 
      30
      Derek A, £33,000, £63,000 
      31
      ];