1 Reply Latest reply: May 30, 2018 8:12 AM by Marcus Sommer RSS

    Load all files from folder  ( FTP and DropBox)

    Daniel Sørensen

      Hi

       

      I am using Qlik sense Cloud to automatically reload data on a daily basis.

      The data I would like to load consist of .csv files from one or more folders, so I don´t only want to load 1 file, but sometimes thousands.

       

      Normally I would just make do this.

      Load
          data1
          data2
      FROM [lib://location-data/*]
      

       

       

      But it fails when I am trying to do the same with DropBox

      LIB CONNECT TO 'Valuereport (qlikcloud_qlikid)';
      Load
          data1
          data2
      FROM [lib://Valuereport (qlikcloud_qlikid_varmekontrol)/folder1\location-data\*]
      
      
      
      
      

       

      And fails when doing it with FTP (Witch I would prefer)

      Load
          data1
          data2
      FROM [lib://valuereportsa (qlikcloud_qlikid)]
      
      
      
      
      

       

      Udklip.JPG