Derived Column transformation


Use the Derived Column transformation to generate new columns in your data flow or to modify existing fields.



Comments

Post a Comment

Popular posts from this blog

How to access output of any activity in another connected activity. - Lookup Activity

Accessing Pipeline Variable Array elements in another activity by. @ variable ('NameOfPipelineVariable')[0]   -- 1st element @ variable('NameOfPipelineVariable')[1]   -- 2nd element @concat( variable ('NameOfPipelineVariable')[0], variable ('NameOfPipelineVariable')[1]) @{activity('Copy1').output.dataWritten} Accesses a property of the previous copy activity and passes the value of dataWritten. or  @activity('LookupTableList').output.value --- this will return full dataset i.e. all records returned by SQL in an activity. ------- @{activity('CopyBlobtoBlob').error.message -  For the failure case, pass the error output instead of  ----------------------------------------------------------------------- First Activity outputs a column named NewWatermarkvalue. select MAX(LastModifytime) as NewWatermarkvalue from data_source_table Below is how you access the output of the above activity in another activity in...
Read more