Hai
I guess, you can use the "Derived Column" activity within your pipeline.
In your pipeline, add a "Derived Column" activity after both the LookupDataModel and DownloadTextract activities.
- Open the settings for the Derived Column activity.
- Define a new column in the "Derived Column" settings. Let's name it "Response" and set its value to
"Research Report: "
. - Make sure the output column is added to the existing schema. You should have a mapping similar to
"Response": "Research Report: "
. This will append the "Response" column to your existing data.
Connect the output of the Derived Column activity to your sink dataset, which is your storage destination.
By doing this, you'll create a new column called "Response" with the value "Research Report: " and append it to each row of your existing data from LookupDataModel. like this.
1. LookupDataModel
|
2. DerivedColumn1
|
3. DownloadTextract
|
4. DerivedColumn2
|
5. Sink (Storage Destination)
If this helps kindly accept the answer thanks much.