Forum Discussion

VanessaFVG's avatar
VanessaFVG
Copper Contributor
Aug 14, 2023

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