15 Replies Latest reply: Sep 22, 2014 4:24 AM by Jyothish KC RSS

    Field not found

    Jyothish KC


      Hi All,

       

      Iam geeting an error field not found [Cont_Year]. Can anyone help?

       

      tab1:
      LOAD
      [Date of contract],
      [Type of contract],
      User,
      rowno() as Sino
      FROM
      [C:\Users\jyothishk\Desktop\KC Test\contract test.xlsx]
      (ooxml, embedded labels, table is Лист1);

       

      tab2:
      load
      User,
      Year([Date of contract]) as [Cont_Year],
      [Cont_Year]&''&[Type of contract]&''&User as Test,
      if([Test]=previous([Test]),'Old User','New User') as User_Status
          
      resident tab1;

       

      Regards

      KC