Columns getting merged while using Uipath data Scraping

[NIMITHA_VENUGOPAL]

Hi All,

I am getting the below output while trying to extract table from wikipedia “List of highest-grossing films - Wikipedia”

Below is the output table that got extracted:

The movie column is getting merged to the first column.

Could anyone please help me to sort out this issue?

[mitesh_parmar]

@NIMITHA_VENUGOPAL

Use attached text file code in “MetaData” or “Edit Defination” in DataScraping Activity

Meta Data.txt (1.0 KB)

[NIMITHA_VENUGOPAL]

Great…It really worked. Thanks so much for the concern.

But I am not able to filter it using below conditions:(
“Films published in or after the year 2015 and gross greater than 1300000000”

Attaching my workflow below…
project.json (1017 Bytes) Main.xaml (14.3 KB) Results.xlsx (7.2 KB)

[mitesh_parmar]

HI @NIMITHA_VENUGOPAL
Instead of Filter datatable, use assign

filterDatatable => extractedData.Select(“[Year] > ‘2015’ AND [Worldwide gross] > ‘1300000000’”).CopyToDataTable

Year and Gross and be pass into variables