Duplicate data in excel ,pdf automation

[ankur_kaushik2 (ankur kaushik)]

here i am trying to extract some data from pdf to excel but its showing 2 duplicate column ,please check image below.

[Palaniyappan (Forum Leader)]

@ankur_kaushik2

pdf to excel but its showing 2 duplicate column

Hi

Is it there in pdf itself
Can we check once pls

Or as a workaround let’s delete that one specific column and then write it to excel

Use remove datacolumn activity

Activities - Remove Data Column

@ankur_kaushik2

[ankur_kaushik2 (ankur kaushik)]

here is the pdf image

[Charbel1 (Charbel)]

Can you send your workflow, please?

[ankur_kaushik2 (ankur kaushik)]

i attachted images,please scroll up

[ankur_kaushik2 (ankur kaushik)]

i attachted ss above,please scroll up

[Charbel1 (Charbel)]

Thanks for that, I just wanted to check the properties of the activities that were used. And those of the Extractor.

[ankur_kaushik2 (ankur kaushik)]

please check the video.

[ankur_kaushik2 (ankur kaushik)]

Anyone?

[Charbel1 (Charbel)]

Did you try the “Remove Data Column” activity before outputting the datatable?

[Gaurav_Malhotra]

In Merge Datatable activity, missing schema property has been set to “ADD”, set it to “Ignore”.

[ankur_kaushik2 (ankur kaushik)]

thanks it worked but i want to know about this,why and when we use it?and why it was showing duplicates.

[Gaurav_Malhotra]

This property comes into action when we are working with two datatables with different
number of columns

• Add: It will return output data table with all columns of two datatables i.e output will contain columns of input datatables + extra columns of second datatable
• Ignore: It will give output datatable with same number of columns of datatable which we have used as input.