Thanks Christopher, But is it possibe to read data from the database from field with XML data type? For example i have a table in the SQL Server, like CustomerInfo:
Customer (varchar 40)
<customer id = 111>
From the example above I need to get data from address and position attributes...
I just use TextBetween function to return whatever is between '<address>' and '</address>' and use it as a field. Turns the db:
Customer XML 111 <customer id = 111>
112 <customer id = 112>
into straight table:
Customer Address Position 111 aaaa bbbb 112 cccc dddd
anyone got this working? i too have a xml field in a database and want to extract some data.
I know TEXTBETWEEN, but with this, you first have to get the whole xml field over using SQL SELECT.
I would like to get my text right in the SQL SELECT. This is much more efficient.
I checked google, but we are on ODBC level here. So not all SQL statements are possible.
Access the menu script and search for the file by the command "FILES TABLE", load only one file so that the structure QLIKVIEW read this file and create a map. If other files have different fields, add these fields using as reference the map created in the script.
Change the the file path excluding the file name and indicate only the destination folder of all files to be loaded with the expression \ *. Xml.
If the file contains more than one table that requires connection, using the file name to create a key between the tables:
FileName (FILE) as key.