I am trying to add data row from one table to another and I am getting the error: Add Data Row: Input array is longer than the number of columns in this table

samuel.chaane · November 2, 2020, 8:28pm

ArrayRow is row.ItemArray
I cloned the DT

Thank you in advance

Sahil_Garg1 · November 2, 2020, 8:50pm

Hi mate,

Can you share more information or screenshots of workflow you are developing.

samuel.chaane · November 2, 2020, 8:54pm

Hi Sahil. I am trying to add data row from one table to another. They have the same structure

Sahil_Garg1 · November 2, 2020, 9:11pm

It seems you are extracting datatable from pdf , first just check whether data table is coming properly or not.

samuel.chaane · November 2, 2020, 9:16pm

Yes it is coming out properly, the only challenge is when I add page two of the pdf to the dataTable.

samuel.chaane · November 2, 2020, 9:54pm

Please find the git repo link https://github.com/spchaane/dataScrapingWorkFlow.git

Sahil_Garg1 · November 2, 2020, 10:05pm

Mate,
Actually am not sure how to get datatable from second page of PDF, we can convert string to datatable but points is that your pdf seems that is contains some headings also.

Let’s see if someone better replies .

Cristian_Negulescu · March 1, 2021, 7:26am

Hello Samuel,
In this video, I have 17 use-cases for extracting tables from PDF and write data in Excel:

Your PDF is at this time:
1:17:10 File 19 PDF with multiple pages and columns with multiple lines

Code:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/PDFdecode.txt

        'FILE1
        Dim strtmp As String
        strtmp = strin.Substring(strin.IndexOf("Number"), strin.IndexOf("Subtotal") - strin.IndexOf("Number")).Trim
        strout = strtmp.Replace(" ", "|")

        strtmp = strin.Substring(strin.IndexOf("Subtotal") + 8)
        strpar = strtmp.Substring(0, strtmp.IndexOf(Environment.NewLine)).Trim


        'FILE2
        Dim strtmp As String
        Dim strout As String
        strout = "Col1|Col2|Col3|Col4"
        strtmp = strin.Substring(strin.IndexOf("Vacancies") + 11).Trim
        For Each line As String In strtmp.Split(New String() {Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)
            If (line.Length > 3) Then
                If (IsNumeric(line(0))) And (line(1) = " ") And (line(2) = " ") Then
                    strout = strout + Environment.NewLine + line.Replace("  ", "").Replace("  ", "|").Trim
                ElseIf (line(0) = "") And (line(1) = " ") And (line(2) = " ") Then
                    strout = strout + line.Replace("  ", "$").Trim()

This file has been truncated. show original

Thanks,
Cristian Negulescu

Topic		Replies	Views
Error:Input array is longer than the number of columns in the table Help datatable , activities	7	24089	October 29, 2018
Add Data Row: Input array is longer than the number of columns in this table error Activities activities , studio , question , system	9	803	June 5, 2023
Add Data Row - input array is longer than the number of columns in this table Studio uiautomation	5	1857	August 13, 2022
Uipath add data row input array is longer than the number of columns in this table Learn excel	9	5422	September 13, 2022
Add Data Row: Error:Input array is longer than the number of columns in this table Studio studio	21	3243	May 20, 2021

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

I am trying to add data row from one table to another and I am getting the error: Add Data Row: Input array is longer than the number of columns in this table

Related Topics