locked
Azure Data Factory loading from JSON to TXT RRS feed

  • Question

  • Hi ,

    I have json file in ADL and i want to convert it into TXT file using Azure Data Factory

    But when i run it,text file has only first record (the first record in JSON)

    The TEST structure of my JSON is :

    {
      "TEST": {
       
        "Test": [
          {
           
            "CC": {
              "Dollar1": 100,
              "Dollar2": 100,
              "Dollar3": 100,
            
            },
            "CC1": {
              "Test1": "23377",
              "Test2": null,
              "Test3": "9691",
            
            }
          },
          {
           
            "CC2": null,
             "CC2": {
              "Test1": "23377",
              "Test2": null,
              "Test3": "9691",
            
            }
    }
    ]
          
    }
    }



    Tuesday, October 1, 2019 10:23 AM

Answers

  • Thanks Olaf for the reply.

    I got answer.

    I need to select Array checkbox if the records are in array format.

    else it takes only one row

    

    • Marked as answer by Khushboo dubey Tuesday, October 1, 2019 11:04 AM
    Tuesday, October 1, 2019 11:04 AM

All replies

  • In which way is this related to Transact-SQL, the topic of this forum? Better post to a more related Forum https://social.msdn.microsoft.com/Forums/azure/en-US/home?forum=AzureDataFactory

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, October 1, 2019 10:55 AM
  • Thanks Olaf for the reply.

    I got answer.

    I need to select Array checkbox if the records are in array format.

    else it takes only one row

    

    • Marked as answer by Khushboo dubey Tuesday, October 1, 2019 11:04 AM
    Tuesday, October 1, 2019 11:04 AM
  • Hi Khushboo dubey,

    Thanks for sharing your findings. It will be beneficial for other members of the community who read this thread. 


    Thank you

    If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.

    Wednesday, October 2, 2019 12:50 AM