I have set up a data table and defined the columns and data types. (Col A, B, C and D, all string)
From a HTML data table having 7 columns I want to extract 4. When setting up the extraction I select the order so the extracted data will be in the correct column in the data table.
When testing the extraction in the table extraction activity it shows as it is extracting the data correct.
However, when the extraction is actually being done (process is running), all columns are being extracted, in the order they have in the table. This is first shown in the locals window, and confirmed by writing the data table to CSV.
I have tried to add a time delay before extraction but that did not help.
Great then when you done the extraction there you can delete the columns which were automatically generated, So that that will be excluded in the extraction of the results
If this is not happening then you need to take a look on the Extract metadata and delete all the columns which are not required by this way also you can exclude the columns you are not required