Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
srikanthpabbu
Partner - Contributor
Partner - Contributor

qlik sense xml upload and break the one of the value into columns

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

typeflagDtTimepacbytzoneservicesessions
appletrueN/A500450,078southxyz5746

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

1 Solution

Accepted Solutions
DavidŠtorek
Creator III
Creator III

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.

View solution in original post

1 Reply
DavidŠtorek
Creator III
Creator III

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.