7 Replies Latest reply: Nov 12, 2013 7:02 AM by Nikolaos Kavroulakis RSS

    Load from field

      Hi all,

       

      I am using load form field in order to get some stuctured complex data from a field see above code:

       

      TorqueData:

      LOAD id,

           serial,

           firmware,

           data_bottom,

           date(testdata) as TestDate;

      SQL select  *

      from payouttensionlog.log

      where testdata>='2013'

      order by testdata desc

      limit 50;

       

      DataTest:

      LOAD

           @1 as Turn,

           @2 as TorqueVal

      FROM_FIELD

      (TorqueData, data_bottom)

      (txt, utf8, no labels, delimiter is ',', msq);

       

      The problem is that i want to associate these load from field data in DataTest wih the id number in Torque Data....

       

      Is there any easy way to achieve this???

       

      Regards

        • Re: Load from field
          Agnivesh Kumar

          Hi,

          You can use like this :

          load  id,

                     serial,

                     firmware,

                     data_bottom,

                     TestDate 

          Resident TorqueData;

           

          if this helps please make correct answer .

          Thanks

          Best Regard

          Agnivesh Kumar.

          • Re: Load from field
            Kabilan Kumarasamy

            TorqueData:

            LOAD id,

                 serial,

                 firmware,

                 data_bottom,

                 date(testdata) as TestDate;

            SQL select  *

            from payouttensionlog.log

            where testdata>='2013'

            order by testdata desc

            limit 50;

             

            DataTest:

            LOAD

                 @1 as Turn,

                 @2 as TorqueVal

            FROM_FIELD

            (TorqueData, data_bottom)

            (txt, utf8, no labels, delimiter is ',', msq);

             

            Tb1:

            Load Turn&TorqueVal as databottom

                 ,Turn

                 ,TorqueVal

            resistent DataTest;

            left join

            Load distinct data_bottom, id resistent TorqueData;

             

            Regards,

            Kabilan K.