Data Factory concatenate two arrays

user_17695449 0
Viewed 35

I have two arrays (job_1 and job_2) which I need to concatenate in one array:

[enter image description here

In DataFlow, I use the code:

union([job_1],[job_2])

I need to have everything in one array this way:

["1428526", "1425403","1425696","1425126","1424631","1381348"]

NOT THIS WAY

["1428526"]["1425403","1425696","1425126","1424631","1381348"]
azure-data-flow azure-data-factory azure arrays
1 Answers
  1. Replace ', [] "' from values of two columns 
    split(replace(replace(replace(job_ids, '"', ''), ']', ''), '[', ''),',')
  2. Add two columns together 
    new = job_1 + job_2
  3. Convert new column to string 
    toString(new)
user_176954490
Related