1 Reply Latest reply: Jul 25, 2018 3:04 AM by David Štorek RSS

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

    srikanth pabbu

      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