Vlookup a number and write it on a csv

[Cheung_Ka_Yan_Cherry]

Hello. I am new to UiPath.


I want to look for the article no. from product code using vlookup and there is an error
VLookup: DoubleConverter cannot convert from (null).
Appreciate you can provide a demo.xaml. Thanks!!!

[Baskar_Gurumoorthy]

Hi @Cheung_Ka_Yan_Cherry

can you use the below linq query to achieve the same things.

DT-Filtered= DT2.AsEnumerable().Where(Function(row) DT1.AsEnumerable().Any(Function(r) r.Field(Of String)(“Article No”) = row.Field(Of String)(“Article No”))).CopyToDataTable()

you can use the above linq query in assign activity.

[Anil_G (Anil Gorthi)]

@Cheung_Ka_Yan_Cherry

Ideally you can read the data and then use join datatable…that will get all the barcodes mapped and then you can write the data back

Cheers

[Cheung_Ka_Yan_Cherry]

Yes the linq query worked. How I can show it on excel? I have tried but the variable type is not correct. Please show the step. Thanks!!

[Baskar_Gurumoorthy]

it was stored it as data table, then you can use write range activity to write the data table in excel.

you can check mark add headers in properties panel. also you can use write range ( excel activity or workbook activity whatever you want.