Forum Discussion

faheem_Latif_BI's avatar
faheem_Latif_BI
Helper I
3 years ago
Solved

DATA from SharePoint

Hi life savers,   I have 2 excel files on Sharepoint, every month our client put latest file for current month.  Now the question is for latest file i consider is as CURRENT table , and for ...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi faheem_Latif_BI 
    if you use the SharepointFolder connector, you first sort the files by creation date in descending order and then select the first 2 rows.
    After that, create an index column and use the different numbers generated there to determine current (0) and previous month (1).

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi faheem_Latif_BI 
if you use the SharepointFolder connector, you first sort the files by creation date in descending order and then select the first 2 rows.
After that, create an index column and use the different numbers generated there to determine current (0) and previous month (1).