Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have an xml file which need to be converted in reporting format such as tabular format.
I directly used the file and qlik sense converted the file into rows and columns . I have xml tag which has multiple value in them and i need to convert them into columns.example as below.
eg:
<event>
<type>apple</type>
<flag>true</flag>
<custom>{DtTime=N/A, pac=500, byt=450,078, Zone=south,Service=xyz,Sessions=5746}</custom>
</event>
i need something like this
type | flag | DtTime | pac | byt | zone | service | sessions |
---|---|---|---|---|---|---|---|
apple | true | N/A | 500 | 450,078 | south | xyz | 5746 |
please let me know how do i change the conditions in load manager to get the results right ? i tried something like this and it did not work
mid(Right(SubField([custom], ',' ,1),Index([custom],'=')-1),2) as Dt_Time
Thanks
Srikanth
Hi,
do you have some unique ID for each record? If yes, than you could use solution attached and have two tables connected via this ID. Or you can join both tables together.
Hi,
do you have some unique ID for each record? If yes, than you could use solution attached and have two tables connected via this ID. Or you can join both tables together.