Forum Discussion
VanessaFVG
Aug 14, 2023Copper Contributor
replace all spaces in column names in a foreach with copy data activity
I have an adf set up to iterate through an api call and ouput several csv files dynamically into azure data lake
that all works fine, but now all i want to do is replace each space in the column names for these variable column names which i dont want to have to be explicit declaring int the schema as it depends on what the api is being passed.
is there a way to do that with the copy activity?
if not i can't figure out how to get a dataflow to do the same copy activity dynamically.
if anyone knows a way to do this, thanks 🙂
No RepliesBe the first to reply