14 Replies Latest reply: Nov 8, 2017 8:38 AM by yaman alsaadi RSS

    Error happened when using FieldValue Function

    yaman alsaadi

      I want to return the first value in key field from my data but i got an error which :

      Table ' New Data ' Not Found.

       

      this my code :

       

       

      NewData:

      Generic LOAD

          Key,

         attribute,

         Value

         

      FROM [lib://personal (desktop-dpummb2_yaman)/Personal Data.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      Load FieldValue('Key',1) as MyPos1

      Resident NewData;