how to check for part of file name string if present and set variable as true using ADF

Question

how to check for part of file name string if present and set variable as true using ADF

Harshith Kuradha Rajappa 6

Im getting child values ( all file names) using Get Metadata stage, i want to check if all my files are present by using only with part of the files name (ex if my file name is 2022_07_01_abc.txt,2022_07_01_cbd.txt,2022_07_01_dqf.txt i want to search if this file is present by searching "abc","cbd",'dqf") and if all my files are present then set the variable as true.
how to achieve this using ADF

1 answer

Your answer

Answer 1

Bhargava-MSFT 31,261 Microsoft Employee Moderator

Hello @Harshith Kuradha Rajappa ,

Welcome to the Microsoft Q&A platform, and thanks for posting your query.

You are looking to use set variable as true if your folder childitems contains "abc","cbd",'dqf" in the fiepath. Please correct me if my understanding is wrong.

You can use GetMetadata and If condition to achieve this.

On the pipeline level, I have written isfilepresent string variable.

I have used Getmetadata activity from the activities section and pointed the dataset to the blob storage(CSV).
on the field list, I have used child items in the arguments

Connect the getmetadata activity to the if condition. I have used the below expression on the activates pane.

@ANDO (and(contains(string(activity('Get Metadata1').output.childItems),'abc.txt'),contains(string(activity('Get Metadata1').output.childItems),'cbd.txt')),contains(string(activity('Get Metadata1').output.childItems),'dqf.txt'))

Inside ifconditon -->True activities, I have used set variable.
If my expression is true, I am setvariable1 else using set variable2 (for False activities)

I hope this helps. Please let us know if you have any further questions.

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-07-16T00:30:31.643+00:00
Hello @Harshith Kuradha Rajappa ,

I am checking in to see if the above answer helped. And if you have any further queries, do let us know.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-07-19T01:33:23.667+00:00

Hello @Harshith Kuradha Rajappa ,

I am checking in to see if the above answer helped. And if you have any further queries, do let us know.

Share via

how to check for part of file name string if present and set variable as true using ADF

1 answer

Your answer