Hi @AzeemK ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
Wildcard for reading source files and Column patterns in derived column can be used to achieve this. Below is GIF for implementation for 3 files where I have altered data in "Accountid" field to 1234 using derived column.
Please suggest for further queries and we will be glad to assist.
-----
- Please accept an answer if correct. 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.