1 Reply Latest reply on Apr 23, 2020 7:36 AM by Varsha Nair

    Create Logical Data Object for XML and JSON

    Varsha Nair New Member

      Hi All,

      I am trying to create LDO for XML and JSON Physical Data Object which are imported as binary resource type. Is this possible in 10.4 of Data Engineering Quality.

      Please let me know if there are any reference materials for this issue.

       

      Thanks.

        • 1. Re: Create Logical Data Object for XML and JSON
          Varsha Nair New Member

          I got the answers to the question.

          A Data Transformation Function needs to be created. Below are the steps:

          1. Create a PDO of the input data.

          2. Create a LDO and drag the PDO into it.

          3. Create a Data Transformation using the wizard and use the schema to create the output.

          4. Select the output data type as Relational Data.

          5. Once complete pull the Data Transformation into the LDO.

          6. Add an Expression to filter out the column names .

          7. Connect the output with the Data Object and run data viewer.