Copy Activity addition column expression

%3CLINGO-SUB%20id%3D%22lingo-sub-2398643%22%20slang%3D%22en-US%22%3ECopy%20Activity%20addition%20column%20expression%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2398643%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%40Community%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETotally%20new%20to%20ADF%20and%20trying%20to%20learn%20from%20past%201%20week.%20Surprisingly%20I%20felt%20it%20is%20more%20tricky'er%20than%20other%20Azure%20services.%3C%2FP%3E%3CP%3EAll%20I'm%20trying%20to%20do%20is%20pretty%20simple.%20Copy%20data%20from%20a%20CSV%20File%20stored%20in%20Azure%20blob%20storage%20in%20to%20Dataverse%20(previously%20known%20as%20CDS).%20I%20just%20need%20to%20replace%201%20source%20column%20text%20before%20sink.%20I%20have%20tried%20to%20use%20Expression%20(%40replace)%20and%20it%20turns%20out%20it%20is%20not%20possible%20to%20refer%20the%20Source%20column%20in%20the%20expressions.%20Is%20that%20true%3F%20Did%20I%20missed%20any%20obvious%20step%3F%20I%20have%20googled%20alot%20and%20I%20couldnt%20able%20to%20find%20proper%20results.%20Any%20help%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ansrikanth_0-1622329102072.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284855iE021E0E6EE8D141C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ansrikanth_0-1622329102072.png%22%20alt%3D%22ansrikanth_0-1622329102072.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E-Srikanth%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi @Community

 

Totally new to ADF and trying to learn from past 1 week. Surprisingly I felt it is more tricky'er than other Azure services.

All I'm trying to do is pretty simple. Copy data from a CSV File stored in Azure blob storage in to Dataverse (previously known as CDS). I just need to replace 1 source column text before sink. I have tried to use Expression (@replace) and it turns out it is not possible to refer the Source column in the expressions. Is that true? Did I missed any obvious step? I have googled alot and I couldnt able to find proper results. Any help?

ansrikanth_0-1622329102072.png

 

Thank you

-Srikanth

0 Replies