azure data factory activity copy with query SOQL llike multiple
I have a pipeline data factory that copy data from salesforce with SOQL query.
this pipeline is receiving a parameter at the execution
B = 'Bryan', 'Jill', 'Anne'
I want to generate a query SOQL and not bring field NAME that contains one of the values in parameter B.
the query should be like that :
select name from customer where (NOT name LIKE '%Bryan%') and (NOT name LIKE '%Jill%') and (NOT name LIKE '%Anne%')
But the problem is that the parameter B it can receive more values, then i am looking to see how to generate the WHERE part dynamically or if you can advice a better approch
I tried with like, IN, i dont find NOTCONTAIN
Read more here: Source link
