search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
9.98k stars 20.95k forks source link

"one-to-many conditions"? #121962

Closed gothick closed 5 days ago

gothick commented 1 week ago

Where this document says "You can add one-to-many conditions as expressions" does it just mean "You can add one or more conditions as expressions"? "one-to-many" has a very specific meaning in databases and I don't really understand what it would mean here.

Thanks!

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

TPavanBalaji commented 1 week ago

@gothick Thanks for your feedback! We will investigate and update as appropriate.

AjayBathini-MSFT commented 1 week ago

@gothick

You are correct that the phrase "one-to-many" has a specific meaning in databases and may not be the most appropriate term to use in the context of Azure Data Factory (ADF) data flows.

In the context of the ADF data flow Alter Row transformation, the phrase "one-to-many conditions" is intended to mean that you can add one or more conditions as expressions to the transformation. Each condition can be evaluated as true or false, and the transformation will apply the specified actions based on the evaluation of the conditions.

For example, you can add a single condition as an expression to the Alter Row transformation, such as age > 18, which will evaluate to true or false for each row in the data flow. You can also add multiple conditions as expressions, such as age > 18 && gender == "Male", which will evaluate to true or false based on the values of the age and gender columns in each row.

In summary, the phrase "one-to-many conditions" in the context of the ADF data flow Alter Row transformation is intended to mean that you can add one or more conditions as expressions to the transformation, and each condition can be evaluated as true or false for each row in the data flow.