CODEWITHSUNDEEP
restazure-data-factorykqlazure-data-explorer
user21510438
user21510438

Reputation:

How to get add a new column value in output table, which activity cani use in Azure data factory

enter image description hereTrying to create a pipeline for copying data from REST API to Kusto table,I get all the columns using mapping, but here I need to concat the 3 columns value into 1 column, how can I do where can I apply

I'm using ADF pipeline for copying data from REST API to Azure Kusto table, I'm able to get the all columns using mapping. But I Kusto table I need to concat the 3 column values into 1 column, how can I do, where can I do, is there any Kusto query updated or any activity add in pipeline. Kusto query: Tablename/extend workitemdatasourceid=strcat(tpid, servicearea,month)/project workitemdatasourceid

Upvotes: 0

Views: 346

Answers (1)

Pratik Lad
Pratik Lad

Reputation: 8402

How to get add a new column value in output table, which activity cani use in Azure data factory

To manipulate data, you need to use data flow activity in ADF. inside data flow add your source as rest API and sink as ADX (Kusto table).

  • After source take a derived column activity and add column with your column name and in expression use concat(column1,column2,column3) it will give you the concatenated value of three columns. enter image description here to concat the values make sure all the column values are of string type or you can convert it into string by using toString() function.

Upvotes: 0

Related Questions