Skip to main content
Question

Data Table Merge action not working with tables extracted from web page

P
Forum|alt.badge.img

Hi, 

I built a bot that goes to https://www.londonstockexchange.com/indices/ftse-100/constituents/table page, and downloads table from first page to one table variable and then a second table from the second page. Both tables are extracted correctly. Then the bot tries to merge both tables and assign the merged value to the first table. However, after performing the merge, the second table is not appended correctly to the first one. Instead, I got additional empty rows added. This behaviour does not appear, if I firstly save tables to csv files, read back and then try merging.

 

Is this an expected Data Table Merge behaviour? I did not find any information about this in the documentation.

W
Dineshkumar Muthu
I
4 people like this
  • W
    william.valdez
  • Dineshkumar Muthu
    Dineshkumar Muthu
  • I
    IagoObrabo
  • E
    EvaG

2 replies

K
Forum|alt.badge.img+1
  • k.abhisarika
  • Cadet | Tier 2
  • 5 replies
  • July 12, 2023

Hi,

 

I have faced the same issue… The reason is we are extracting the table data dynamically and extracted table in AA has column Names with digits. AA is unable to merge based on default created index numbers.

 

Solution: Instead of Merge option → Use loop with Data Table:Insert row command

M
1 person likes this
  • M
    Maverick 1346
J
Flight Specialist | Tier 4
Forum|alt.badge.img+8
  • jackson
  • Flight Specialist | Tier 4
  • 23 replies
  • March 19, 2025

This needs to be a defect !!  

The problem i am trying to solve is merging 4 csv files but, because these are loading from JSON strucutres they have different header records.  So in order to change the header record i need to open the CSV files without headers.   Sure would be nice if we had a change header feature!! ;  However, in this loop i cannot use the merge function because of the fact stated above AA fails to merge when using default headers.  

Based on the failure of the merge function i now have to open and close the csv files 3 times before i have my final consolidated spreadsheet this simply feels like a poor solution.

Also, given these CSVs have over 6000 rows i dont think a loop with addrow is a reasonable option.

 

 

Jackson

Reply


Terms & ConditionsCookie settings

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