Hi, I have 1 DT. With the below columns : SlNo,TRANSACTION_ID,PNR_NO,CLIENT TRANSACTION ID,BOOKING_AMOUNT,PG NAME,CLASS,TRANSACTION_DATE,USER_ID,PRINCIPAL_USER_ID, AMC_Charge(Including GST). I want to introduce a new Column(CLIENT TRANSACTION ID + BOOKING_AMOUNT) in the data table. This is equiva…

[image] Add column with name TRAN_ID_BOOKING_AMOUNT 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)

New column in a data table by concatenating to existing columns

Help Studio

NIVED_NAMBIAR (NIVED N) March 9, 2021, 2:03pm 11

Hi @shrayud

You can try invoke method for concatenating columns

check link

Regards,

Nived N

Happy Automation

Topic		Replies	Views
Adding a new column to a datatable which concatenates other columns data Help	7	2537	May 18, 2019
How to create a new column in DataTable from the existing ones Help	7	6449	March 30, 2020
Append DT Column to Existing DT Help	8	1634	August 30, 2019
HOW TO CONCATENATE TWO COLUMNS AND GET IT AS A NEW COLUMN IN DATA TABLE? Help excel , activities , studio	5	9626	May 14, 2019
Adding a column to the Data Table after a data scrape Help	15	3555	December 2, 2020

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

New column in a data table by concatenating to existing columns

Related Topics