Hi,
I have 2 lookup activities in my pipeline. The first Lookup is querying a table and outputs a list of tables in the below format.
{
"count": 3,
"value": [
{
"TABLE_NAME": "CUSTOMERS"
},
{
"TABLE_NAME": "SALES"
},
{
"TABLE_NAME": "PITCH"
}
],
"effectiveIntegrationRuntime": "AutoResolveIntegrationRuntime (Mumbai)",
"billingReference": {
"activityType": "PipelineActivity",
"billableDuration": [
{
"meterType": "AzureIR",
"duration": 0.016666666666666666,
"unit": "Hours"
}
]
},
"durationInQueue": {
"integrationRuntimeQueue": 0
}
}
The other lookup fetches an excel which has multiple columns, one of which is SOURCE_TABLE
My objective is to filter out the rows from the excel where SOURCE_TABLE
matches with the values of the first Lookup. For this I am iterating over a ForEach activity as below.
@activity('lookup01').output.value
Inside it I have a filter activity, that has item as `@activity('lookup_excel').output.value`
and condition as @equals(item().SOURCE_TABLE,activity('lookup01').output.value)
The filter activity is not able to filter the rows although the pipeline is running fine. Any help is hugely appreciated.