Skip to main content
Question

Join datatable when i don't have a column name, but only column index

  • February 17, 2023
  • 4 replies
  • 165 views

Forum|alt.badge.img+1

I am trying to perform a join using 2 Data Tables. DataTable1 is retrieved from a webpage where the column names are not being retrieved so I only have the column indexes. 

I don’t know how to perform a join when the join action is asking for the column name only and there is no option to provide a column index instead. 

 

4 replies

Raul Jaimes
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • 494 replies
  • February 17, 2023

@ibtasaam 

Insert a dummy row as headers with Data Table: Insert row action.

 

 

 

HTH

Regards


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 1 reply
  • February 17, 2023

Hi Raul , 

Thanks for your prompt reply. I am still not sure if this has worked to update the table column names. Let me share some screenshots to see if you can advise any further. 

 

But once I add this row into my data table as you described the Name doesn’t seem to apply to the relevant columns. 

 

As you can see the dummy row is present but still the columns only have index and no names.

Hope you can help further.

Thanks


Raul Jaimes
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • 494 replies
  • February 17, 2023
ibtasaam wrote:

Hi Raul , 

Thanks for your prompt reply. I am still not sure if this has worked to update the table column names. Let me share some screenshots to see if you can advise any further. 

 

But once I add this row into my data table as you described the Name doesn’t seem to apply to the relevant columns. 

 

As you can see the dummy row is present but still the columns only have index and no names.

Hope you can help further.

Thanks

 

I get it.  Let me check other approach.

 

 


Raul Jaimes
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • 494 replies
  • February 17, 2023

@ibtasaam 

In the meanwhile, take a look in the follow bot form Bostore:

https://botstore.automationanywhere.com/bot/data-table-additional-functions

Regards


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings