I want my table name should be like [details] because my sql server support this only

Veerareddy Gangula 1 Reputation point
2022-08-20T09:57:18.68+00:00

I have taken get metadata to know what files in my folder and then I applied for-each loop activity to it.

Now when i created set variable as table name and assigned below text as dynamic content which is from for loop

@item.name

The table name is getting like 'details'

It's correct

But I want my table name like this [details]

When i use @markus.bohland@hotmail.de ('[',@item.name,']')

Not working

Can anyone help me
233029-inbound5960541267243723945.jpg233030-inbound4226345656697965352.jpg

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,526 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-08-22T11:33:49.27+00:00

    Hi @VeerareddyGangula-7073 ,

    Thank you for posting query in Microsoft Q&A Platform.

    From your file name if you want to take value into variable as details, then use dynamic content for Set variable as @{split(item().name,'.')[0]}
    From your file name if you want to take value in to your variable as [details] then use dynamic content for Set variable as [@{split(item().name,'.')[0]}]

    233486-image.png

    Hope this helps. Please let us know if any further queries.

    ------------

    Please consider hitting Accept Answer button. Accepted answers help community as well.