How do i add different columns between a datatable

Help Studio
1

A spreadsheet table displays deposit details including date, banking type, account numbers, cost centers, and respective amounts. (Captioned by AI)
A spreadsheet table displays deposit details including date, banking type, account numbers, cost centers, and respective amounts. (Captioned by AI)1027×541 76.3 KB

Hi,

I want to add column in column b and c and then column f another column. How do i do it?

2

@mark_rajkumar1

if needed in excel you have insert column activity

if you need in datatable then use invoke method with setOrdinal

give the index of the column where to be inserted …index starts from 0

cheers

cheers

3

Hi @mark_rajkumar1

Use the Insert/Delete Columns activity.

To Insert Between B and C

  • Set the ColumnIndex to 3 (since columns are 1-indexed: A=1, B=2, C=3).
  • This will insert a new column before C, effectively placing it between B and C.

To Insert at Column F

  • Set the ColumnIndex to 6 to insert a column before column F.

All the best.

4

Hi can i have a workflow

5

Hi @mark_rajkumar1 ,
please check below screenshot.

The image displays a workflow sequence demonstrating workbook operations, where a worksheet is read, a new column is added via code, and the data is finally written back to the same workbook. (Captioned by AI)
The image displays a workflow sequence demonstrating workbook operations, where a worksheet is read, a new column is added via code, and the data is finally written back to the same workbook. (Captioned by AI)523×524 14.7 KB

6

Use the Add Data Column activity to add the columns. Then use the Filter Data Table activity and on the second tab set it to “Keep” and list the columns in the order you want.

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.