10 Replies Latest reply: Dec 13, 2016 7:11 AM by Nitin Gaikwad RSS

    How to Check if value exists with date

    Dipesh Vadgama

      Dear All,


      I am trying to find if Current week "Number" exist in pervious week "Number".

      I try to use Exists & match but no use.




      LOAD [Date],



          Match(if([Date]>Today()-6,[Number]),if([Date]<=Today()-6,[Number])) as "Repeated"


      FROM [lib://Dat.xlsx]

      (ooxml, embedded labels, table is Sheet2);