Query for Fetching XML File

Fri, 17 Oct 2014 08:35:03 GMT

Dear All,

While fetching the data from XML file I am facing some issue , mentioned below.

[Authentication Server]:

LOAD DISTINCT
name as [%AuthServer],
name as [Auth. Server Name],
[ldap/settings/ldap-server-type] as [ldap-server-type],
%Key_configuration_4E438F6447E19AC9 as [Key Configuration],
[%Key_auth-server_70F77F3C5C5BCD9F] as [Key Auth-Server]
FROM [ive-export.xml] (XmlSimple, Table is [configuration/authentication/auth-servers/auth-server]);

[Access-url]:
LOAD DISTINCT
[user/realms] as [%AccesUrl],
[user/meeting-url] as [meeting-url],
[user/realms] as Realm,
[%Key_configuration_4E438F6447E19AC9] as [Key Configuration],
[%Key_access-url_2AF4BC2ACFC30E4D] as [Key Access Url]
FROM [ive-export.xml] (XmlSimple, Table is [configuration/authentication/signin/urls/access-urls/access-url]);

[User Group]:
LOAD DISTINCT
[name] as [%UserGroup],
[name] as [Security Group Name],
[%Key_auth-server_70F77F3C5C5BCD9F] as [Key Auth-Server]
FROM [ive-export.xml] (XmlSimple, Table is [configuration/authentication/auth-servers/auth-server/ldap/server-catalog/groups/user-group]);

The value of Configuration key is coming as 0 always , and due to this it's unable to do the preoper mapping.

Could any of you kindly suggest how could I overcome from this issue.

Thanks

D J

topic Query for Fetching XML File in QlikView

Query for Fetching XML File