Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,725 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hey Team
How to filter data in adf pipeline from json file
where bar <> "data"
{
"foo": {
"bar": "data",
"baz": "data"
}
}
Hi Vineet S ,
Thankyou for using Microsoft Q&A platform and thanks for posting your query here.
I understand that you are trying to filter data of json based on certain condition.
You could try to leverage mapping dataflow for this purpose in Azure data factory.
Relevant resources: How to filter out records based on pipeline parameter using mapping dataflow
How to convert a JSON record into NESTED JSON using mapping dataflow
Hope it helps. Kindly accept the answer by clicking on Accept answer
button. Thankyou