topic Re: Need help with loading xml in QlikView

Need help with loading xml

Mon, 06 Jul 2015 06:53:37 GMT

Need to load the attached excel and load the data as following where the attribute id is column name

SYSTEM ID ,0x11f56,0x12d7f,0x12b4c

1000,4,10.XX.YY.XXX,DOWN

1001,4,10.xx.x.xx,UP

jonathandienst — Mon, 06 Jul 2015 07:26:43 GMT

This will do it

System:

Mapping LOAD %Key_SYSTEM_E1A50E403A5F81B7 as %Key1,

FROM (XmlSimple, Table is [SYSTEM-response-list/SYSTEM-responses/SYSTEM]);

Attributes:

Mapping LOAD RowNo() As %Key2,

attribute%Table

FROM (XmlSimple, Table is [SYSTEM-response-list/SYSTEM-responses/SYSTEM/attribute]);

AttributeID:

LOAD id,

ApplyMap('System', %Key_SYSTEM_E1A50E403A5F81B7) As SystemID,

ApplyMap('Attributes', RowNo()) As Value

FROM (XmlSimple, Table is [SYSTEM-response-list/SYSTEM-responses/SYSTEM/attribute]);

Mon, 06 Jul 2015 10:52:13 GMT

HI i Want to create 3 columns as 0x11f56,0x12d7f,0x12b4c along with its values but here only one colum id is getting genarated

Fri, 10 Jul 2015 09:39:56 GMT

Some of the values in Value Column are in HEX format. How do i convert those in Decimal in load Script here

jonathandienst — Fri, 10 Jul 2015 09:49:55 GMT

Like this:

Num(Num#('C7', '(HEX)'))

Num# interprets the hex value, Num formats it to display decimal

The case of HEX should be the same as the case of the A-F in the hex number.

Num(Num#('c7', '(hex)'))