New column in a data table by concatenating to existing columns

image

  1. Add column with name TRAN_ID_BOOKING_AMOUNT
  2. Then use assign with below expression
DailyBookingDT.Columns("TRAN_ID_BOOKING_AMOUNT").Expression = "[CLIENT TRANSACTION ID] + BOOKING_AMOUNT"

Please find attached the sample flow for reference.

test_concatenate (1).xaml (5.9 KB)

4 Likes