3 Replies Latest reply on Feb 11, 2020 5:14 PM by Mohammed Asif Huque

    How to Explode Attribute Keeping Entries with Only One Value

    Jessiele Rodrigues
      Share This:

      I now that ADDM explode query removes lines where the exploded list is empty (Explode - ADDM 10.2 - BMC Documentation), however I have a situation where some entries are not empty but have only one value (not a list).

       

      Is there some way to have only one query to return the result with the list exploded and keep the entries with only one value?

       

      Example of query result before explode:

      Server Name          Application Name

      svr_1                      App1

      svr_2                      ["App1","App2"]

       

      Result after explode (not what I expect):

      Server Name          Application Name

      svr_2                      App1

      svr_2                      App2

       

      Expected result that I am looking for:

      Server Name          Application Name

      svr_1                      App1

      svr_2                      App1

      svr_2                      App2