<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Importing using location variables in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Importing-using-location-variables/m-p/318943#M1179095</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;HI, im trying to query the imdb database for info on the movies that i have stored on my hard drive.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I figure,I can take the filename, and use this to query the imdb database for info about the movies, so that I can do the things shown in the movies demo, but with my movies, and without creating manual databases.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have found the website &lt;A href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com&lt;/A&gt;/ whereby if you put &lt;A href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=&lt;/A&gt;"Film name" the results shows text about the films.&amp;nbsp; Is there a way to have qlikview use the results of a table to search different locations?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I.e. my table has a column called file name with the following values:&lt;/P&gt;&lt;P&gt;The Silence of the lambs&lt;/P&gt;&lt;P&gt;The Matrix&lt;/P&gt;&lt;P&gt;Kill Bill&lt;/P&gt;&lt;P&gt;etc&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and have it search &lt;A class="active_link" href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=The Silence of t&lt;/A&gt;he lambs&lt;/P&gt;&lt;P&gt;&lt;A href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=The &lt;/A&gt;Matrix&lt;/P&gt;&lt;P&gt;&lt;A class="active_link" href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=&lt;/A&gt;Kill Bill&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;etc?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 26 Feb 2012 00:20:20 GMT</pubDate>
    <dc:creator />
    <dc:date>2012-02-26T00:20:20Z</dc:date>
    <item>
      <title>Importing using location variables</title>
      <link>https://community.qlik.com/t5/QlikView/Importing-using-location-variables/m-p/318943#M1179095</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;HI, im trying to query the imdb database for info on the movies that i have stored on my hard drive.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I figure,I can take the filename, and use this to query the imdb database for info about the movies, so that I can do the things shown in the movies demo, but with my movies, and without creating manual databases.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have found the website &lt;A href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com&lt;/A&gt;/ whereby if you put &lt;A href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=&lt;/A&gt;"Film name" the results shows text about the films.&amp;nbsp; Is there a way to have qlikview use the results of a table to search different locations?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I.e. my table has a column called file name with the following values:&lt;/P&gt;&lt;P&gt;The Silence of the lambs&lt;/P&gt;&lt;P&gt;The Matrix&lt;/P&gt;&lt;P&gt;Kill Bill&lt;/P&gt;&lt;P&gt;etc&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and have it search &lt;A class="active_link" href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=The Silence of t&lt;/A&gt;he lambs&lt;/P&gt;&lt;P&gt;&lt;A href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=The &lt;/A&gt;Matrix&lt;/P&gt;&lt;P&gt;&lt;A class="active_link" href="http://www.imdbapi.com/?t=American%20Gangster"&gt;http://www.imdbapi.com/?t=&lt;/A&gt;Kill Bill&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;etc?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 26 Feb 2012 00:20:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Importing-using-location-variables/m-p/318943#M1179095</guid>
      <dc:creator />
      <dc:date>2012-02-26T00:20:20Z</dc:date>
    </item>
  </channel>
</rss>

