Extra Column being Render in the excel file

Help Studio
, , ,
1

Hi Community,

I not sure what i have edited in the Uipath and it give me result as per screenshot below:

Original excel file
image

Output (after run the UiPath)
image
As you can see, there was extra column being rendered in this case.

May i know what could go wrong normally in this case?

Thank you.

2

@SH_94

Can you please tell me the steps you followed here. So that we can check and help you where it went wrong.

3

Hi @SH_94,

There must be 2 blank columns in the input excel file, that’s why it is adding up 2 columns to the data table.

4

Hi @lakshman ,

I not sure which part i did wrong and i shared the screenshot for the every step that i touch with the excel file.

  1. Screenshot one

    image
    image927×389 15.6 KB

  2. Screenshot two

    image
    image1012×412 14.2 KB

  3. Screenshot three - I not sure why it show 9 as i didnt select 9 column.

    image
    image1062×402 16.2 KB

  4. Extract data from browser and use add data row

    image
    image985×472 26.4 KB

  5. then write the output.

    image
    image1000×331 11.2 KB

5

Hi @shivagowdavarad ,

May i know how do i check whether 2 blank column exist or not? as from my view , it does not have any empty column

6

@SH_94

I can’t see any bug here. Can you run the process in Debug mode and check values in Immediate panel where the extra columns are getting added.

7

Dear Jacob,

Are you using Build Datatable activity anywhere to create the table and using it?
If so please delete the default columns in BuildDatatable activity and give a try

Thanks and Regards,
GeetishreeRao

8

The extra columns are in your datatable. Use Debug instead of Run. Set a Breakpoint on the next activity after your datatable is populated. Then when it stops at the Breakpoint you can look in the Locals tab to see the columns that are in the datatable. You’ll probably want to use a Filter Datatable activity to remove the unwanted columns.

9

Hi @lakshman ,

I manage to find it but i dunno where should edit or delete it.

image
image814×276 11.6 KB

Do you know how to do it?

10

Use Filter Datatable. Set the in and out DTs to the same datatable. Don’t configure the filter tab. Go to the second tab and set it to keep Document No., Status, and Attachment Found columns.

1 Like