Lookup a record of Excel file 1 in Excel file 2 and set column if found

Help
1

Hi!

Imagine I have the following Excel file 1:
Excel%20file%201

Imagine that I have the following Excel file 2:
Excel%20file%202

I want to make a simple vlookup and check which of the the NB values (1st Excel column) of all the records of Excel file 1 are in Excel file 2. And create a column in Excel file 1 with a “1”, of the records of Excel 1 which have been found in Excel file 2. The result would be this:
Excel%20file%201

I tried to use the new “lookup” activity, but I wasn’t able to do anything with it.
Does anyone have any idea how to do this in an easy manner?

Thank you!

2

Hi jcab, to achieve this you can simply load both sheets into a DataTable and use the select statement on the DataTable to find it. I attach a small workflow to demonstrate this. This workflow assumes the Found column has already been added in Excel1.ExcelLookup.xaml (8.2 KB)

2 Likes
3

@jcab
is this what you want ?

matchrecords.xaml (9.5 KB)
Get Non-matched Items.xaml (9.7 KB)

1 Like
4

@antonroux, that looks great, thanks!

5

Thanks :slight_smile:

Could you also please attach the workflow “Component for Two Datatable Column Match and Get The Matched Records.xaml” you are invoking ? :slight_smile:

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.