Add data row with extract datatable positioning of the columns

[hemuli (Henri Vuolle)]

Hi, I’m tryin to add datarow into the table and then on the next row add result of the data scraping extract.

The workflow:

Build datatable with four columns

Now based on the Element exist activity add data row {“nimi”,var1} or {“nimi”,var1,var2,var3}

To this phase everything goes ok, but if element exists then add data row, ExtractDataTable offsets the values from the extraction as it creates two new columns after the built data columns.

What I’m trying is to have the end result like datatable be like:
Label,Value,Label2,Value2
“nimi”,var1,ExtractedData1,ExtractedData2
“nimi”,var1,var2,var3

but the end result goes like this:
Label, Value,Label2,Value2,Column,Column
“nimi”,var1,“”,“”,ExtractedData1,ExtractedData2

Does anyone have any idea, how this should be done to get it right?

Thanks :)!

[pattyricarte (Patty Boy)]

Hi @hemuli

Were going to create a test scenario. Can you try to convert your datable to outputdatatable and send it msgbox before adding the datarow and after adding the datarow to see the difference.

cheers:D

Happy learning

[hemuli (Henri Vuolle)]

Hi,sure! Here are the screen shots

[hemuli (Henri Vuolle)]

hi, one more, here is the output msg box Before adding the data row

[hemuli (Henri Vuolle)]

Hi, have you managed to come up with any idea with this?