Share via

filter activity

arkiboys 9,711 Reputation points
2022-02-02T14:45:16.89+00:00

Hello,
After the filter activity (Filters a config.csv file which has several columns but filters to one row), I am using an execute pipeline which calls copy activity
inside the execute pipeline, I have:
@activity('Filter 1').output.DatabaseName.value --> I am trying to get the value of the DatabaseName column for the filtered raw

The error is:
error code: bad request,
the expression can not be evaluated because propert DatabaseName does not exist

Question:
How can I get the values in each of the columns of the filtered raw?
Thanks

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

Answer accepted by question author

AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator
2022-02-02T16:21:44.38+00:00

Hi @arkiboys ,
Thanks for using Microsoft Q&A platform and posting your query.
If my understanding is correct, you want to pass the output of the filter activity to another pipeline via execute pipeline activity. You can't directly use the output value of one pipeline into another .
Rather, you can create a parameter in child pipeline . And, in the parent pipeline provide the value for the parameter.

170662-image.png

170654-image.png

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.