How Insert or append the Result to ADX

Question

I have One Lookup Activity In ADF where o am reading rows from Kusto(ADx) table and write that rows into another ADx table .

But I am getting command issue.

Pipeline:

Lookup Activity:

Test_emg1
| project splitted=split(output, ',')
| mv-expand id=splitted[0]
|mv-expand Start=splitted[1]
| mv-expand End=splitted[2]
|project id,Start,End

Update ADx command:

@concat('.set-or-append Test_final <| (',activity('Test__final').output')')

Error:

getting synatx Error.

Answer 1

I got the answer. I have just reform my query. like. @concat('.set-or-append Test_final <| print(dynamic(',activity('Test__final').output')'))

Now its working fine.