DataTable Column Name

Help Orchestrator
,
1

Hi All,

My actual column names are as below

A spreadsheet titled "Copy of TG RI Report view" shows a table with columns including OppVerification, msft_ri_order_details Name, Start Date, End Date, Enrollment, Billing Group ID, Reservation Order, Subscription ID, Microsoft Customer Name, MSFT Commitment, and various purchase amounts, containing data from five rows of entries. (Captioned by AI)
A spreadsheet titled "Copy of TG RI Report view" shows a table with columns including OppVerification, msft_ri_order_details Name, Start Date, End Date, Enrollment, Billing Group ID, Reservation Order, Subscription ID, Microsoft Customer Name, MSFT Commitment, and various purchase amounts, containing data from five rows of entries. (Captioned by AI)3428×524 119 KB

But when I write the data table to excel. Why I don’t get the exact column names as in application

I get as below

The spreadsheet displays data with columns for details, start date, and end date, with most rows from early October 2024, ending in October 2025. (Captioned by AI)
The spreadsheet displays data with columns for details, start date, and end date, with most rows from early October 2024, ending in October 2025. (Captioned by AI)1794×1230 206 KB

2

@dutta.marina,

These must be changed in Table Data Extraction. Check what column names are there in Extraction wizard.

Check at Datatable level before writing it to Excel.

If you need to change the column name in Datatable use below snippet in Assign activity.

dtInput.Columns(columnIndex or columnname).ColumnName = "New Column Name"

3

Hello @dutta.marina

You can define the column names in the Table Extraction Wizard.
Alternatively you can ajust the names in the “Properties” panel of your “Table Extraction” activity.

image
image960×606 36.3 KB

Regards
Soren

4

Hi,

It seems that the other attributes within the elements containing the column names are also being written to the column name. Since all of these columns have sorting functionality, it looks like ‘sort,’ ‘ascending,’ and ‘descending’ appear in every column. To avoid this, you can manually remove or replace the unwanted text in the column names within the datatable before writing it.

Alternatively, you can use the Find Children activity to retrieve the content of each column individually and then combine them.

Regards,

Kardelen

5

Hie @dutta.marina when you are extracting data from the website before saving it check the column name that bot is extracting and edit as per your suitable name.
cheers Happy Automation

6

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