This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Hi, How to look up on blob storage example there is column in blob storage name called company code' in a, b, c, d) based on it should pass that value to copy activity... Pls share screenshot
File :
lookup wherein the dataset is file path in blob:
output :
then use for each to iterate across each companycode
and then use copy activity within for each and you can use item() that would give you value of the company code in current iteration within your copy activity as parameter or a new column value based on your use case
But there are multiple files
And what condition we should write for lookup as there are other columns available
Can you please provide an apt description of your ask rather than single line statements as that would help us avoid multiple threads!!
output:
Now rather than using item() you would have to use item().CompanyCode
In case if there are multiple files, assuming all files have the same structure,
You can use Copy activity at the start to merge all files into a single file and then use it within the lookup:
https://www.sqlservercentral.com/articles/merge-multiple-files-in-azure-data-factory