ADF - String to Json Array Cast Issue

Question

ADF - String to Json Array Cast Issue

Tomar, Abhishek 6

Ho can i remove single item array and just display as normal json string type.

I am trying to get first element from all array and want to display as string but when i'm trying this with derivedColumn1, at function its showing that my columns in not array.

How can i convert my columns in array and get first element.

This is my output.

    {  
      "partition_key": 2031,  
      "npi": 111111,  
      "reporting_entity_name": "ABC",  
      "billing_class": ["professional"],       //REMOVE ARRAY  
      "negotiation_arrangement": "ffs",  
      "description": "sdfs s df sd f sd f sd f sd f sd f",  
      "plan_id_type": ["recon-key"],      //REMOVE ARRAY  
      "expiration_date": [0000000],    //REMOVE ARRAY  
      "plan_name": ["YAO TOMU ROAN"],   //REMOVE ARRAY  
   }

ERROR

PIPLINE

derivedColumn1

AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2022-03-11T07:05:06.55+00:00

Hi @Tomar, Abhishek ,
Just following up to see if the answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

1 answer

Your answer

AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2022-03-11T07:05:06.55+00:00

Hi @Tomar, Abhishek ,
Just following up to see if the answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

Answer 1

AnnuKumari-MSFT 34,556 Microsoft Employee Moderator

Hi @Tomar, Abhishek ,

Thankyou for using Microsoft Q&A platform and posting your query.

As I understand your query here is that you want to convert Items of array into string. For that purpose, you are trying to use at function but it's not working as expected in your case. Please correct me if my understanding about your query is wrong.

I tried to repro your scenario and was able to get the expected output. Alternatively, you can also use expression as : billing_class1 for the same output.

Please validate that the datatype for those columns is an array in the inspect tab of source transformation. If it's not , then the Json is not properly formatted or there is an issue with import schema.

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2022-03-10T06:55:24.837+00:00

Hi @Tomar, Abhishek ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
Tomar, Abhishek 6 Reputation points

2022-03-11T12:07:14.123+00:00

My data comes in a string like this ["data1"] when I'm trying to convert this using array then its returning output like below.

Currently i fixed my issue using replace function - toString(replace(replace(toString(billing_class),'["', ''),'"]',''))

More Details

InputData=["Data1"] as string

when I'm trying to convert this using array

output=array(InputData)

PRINT --> output = [["Data1"]]

when I'm trying to get the item used then it's giving me the same result.

fmt=at(output,1)

PRINT --> fmt = ["Data1"] as string

Share via

ADF - String to Json Array Cast Issue

1 answer

Your answer