4 Replies Latest reply: Nov 28, 2016 7:17 AM by Turan Kibar RSS

    Qlik Sense - R integration  .csv file has tags!

    Turan Kibar

      I am trying to integrate R and Qlik Sense so I am following this . Qlikview + R

      When I am in 1st step, I can create the table by this script as tutorial shows.

      But what I get is this file on the bottom and this file does not look like a .csv or a .txt file. There are lots of tags in it so R does not recognize this. 

      What can I do to make this file a proper .csv or .txt file?

       

      // STEP 1 . Create data and store in csv
      // ------------------------------------- ---------------------------------------

      Data: LOAD * INLINE [
          Name, Age, MontoConsumo
          Juan, 55, 19
          Peter, 30, 66
          Maria, 70, 88
          Isabel, 71, 80
          Diego, 68, 34
          Luis, 19, 101
          Lucia, 46, 42
          Francisca, 38, 43
          Alberto, 69, 23
          Garcia, 54, 45
          Soto, 82, 98
          Victor, 28, 31
          Esteban, 19, 76
          Jose, 29, 61
          Bob, 16, 96
          Maciel, 75, 5
          Nelson, 60, 51,
          Ale, 79 31
          Alberto, 21.98
          Lee, 82.97]
      ;

          store Datos into 'lib://QlikRFolderConnection/Datos.csv (txt)';

       

       

       

      garip.jpg

       

       

       

       

      But what I get is this file and this file does not look like a csv or a txt file. There are lots of tags in it so R does not recognize this. 

      What can I do to make this a proper csv file so that R recognizes it ?