'String' does not match the field: 'condition' in Data fcatory Filter activity

Question

'String' does not match the field: 'condition' in Data fcatory Filter activity

Srikanth Gandam (US) 1

Filter confitionis throwing error when I am trying to filter childitems from Getmetadata

Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2022-07-11T12:20:28.883+00:00

What is your requirement in filter condition?
because the output of this expression is a normal name and not a condition.

you need to have some filter logic, please refer the below blog:

https://azurelib.com/how-do-you-use-filter-activity-in-azure-data-factory/
Srikanth Gandam (US) 1 Reputation point

2022-07-11T12:41:07.527+00:00

Thanks for ur reply.

I am trying to replace the name BANK from the folder names.
Input from Get metadata - BANK_FILE_CREATED_DATE=2011-01-01

Output of filter should be : FILE_CREATED_DATE=2011-01-01

1 answer

Your answer

Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2022-07-11T12:20:28.883+00:00

What is your requirement in filter condition?
because the output of this expression is a normal name and not a condition.

you need to have some filter logic, please refer the below blog:

https://azurelib.com/how-do-you-use-filter-activity-in-azure-data-factory/
Srikanth Gandam (US) 1 Reputation point

2022-07-11T12:41:07.527+00:00

Thanks for ur reply.

I am trying to replace the name BANK from the folder names.
Input from Get metadata - BANK_FILE_CREATED_DATE=2011-01-01

Output of filter should be : FILE_CREATED_DATE=2011-01-01

Answer 1

Nandan Hegde 36,716 MVP Volunteer Moderator

Filter activity is used to filter the array and not replace any data within an array.
In case if you want a variable with the new path names, than use Set variable activity.

AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-07-18T06:38:10.093+00:00

Hi @Srikanth Gandam (US) ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

Share via

'String' does not match the field: 'condition' in Data fcatory Filter activity

1 answer

Your answer