How to concatenate column names only not values

[Sai_Kumar7 (Sai Kumar)]

Can we concatenate two column names instead of taking column values?

[arjunshenoy]

Hi @Sai_Kumar7, welcome to the Community.

Can you please share a sample input & expected output, so that we can analyze your requirements?

Best Regards.

[rlgandu (Rajyalakshmi Gandu)]

Hi,
I hope this will help you,
Read range workbook to read the excel
Take for each row in datatable
row(“NewColumnName”) = row(“Column1Name”).ToString + row(“Column2Name”).ToString
After use write range workbook activity.
Thank you.

[Sai_Kumar7 (Sai Kumar)]

The above image in column names when giving is not working in the formula.

[Anil_G (Anil Gorthi)]

@Sai_Kumar7

You should be using the cell number not the columns here in excel formula

Cheers