7 Replies Latest reply: Aug 30, 2017 2:58 PM by ALEN ARUTYUNYAN RSS

    Load HTML data table

    ALEN ARUTYUNYAN

      Hi Qlikview team, for some reason, I have a script that gets currency data from a website and for some reason, I am not able to pick up the data from the website as the script may not be correct anymore.  Can anyone help modify the script to be able to pick up the right data.  Below is my script.  I am asking it to go and find me the CNY (Chinese Yuan) currency from the link below but for some reason, it's not picking up the data anymore. 

       

       

      LOAD 'CNY' as [Currency Unit],

           left(@3, 7) as [Units per USD]

      FROM

      [http://www.xe.com/?c=CNY]

      (html, codepage is 1252, no labels, table is @1) where recno() = 8;