Im trying to use Lookup data table

Help Studio
, ,
1

Im trying to use Lookup data table for two excel files .One excel file has column name : collector and second excel file has column name : Collector name and mail ID . I need to compare column name : collector and collector name and get the mail ID values. Then i need to add all the all mailID in a single mail. I have attached sample files.
Book1.xlsx (9.5 KB)
Book1.xlsx (9.5 KB)

2

Book1.xlsx (9.5 KB)
Book2.xlsx (8.9 KB)
These are the correct sample file

3

Hey,

You have attached two same files, both the files are same!

Edit: Got it

4

Sorry, I have attached the correct files now.

1 Like
5

PFA: Use attached .xaml
Lookup_forum.xaml (8.7 KB)

LinQ:
(
From row In dt_Mail
Join main In dt_InputTable
On row(“Collector”).ToString Equals main(“Collector”).ToString
Select row(“Mail ID”)
).ToArray

Output : Array

Regards,
Ajay Mishra

6

Im unable to open the Xaml file.it is showing it has been removed

7

Hi @sathish_moorthy

Invoke Code used:

For Each row1 As DataRow In dt1.Rows
    For Each row2 As DataRow In dt2.Rows
        If row1("Collector name").ToString() = row2("Collector").ToString() Then
            row2("Mail ID") = row1("Mail ID")
        End If
    Next
Next

Invoked Arguments:

image
image888Ă—257 10.1 KB

Check the below xaml file:
Sequence5.xaml (8.0 KB)

Output:
image

Hope it helps!!

8

Try this:

LinQ_Lookup_Forum.zip (16.8 KB)

You will get Array of String as a output(Check it on immediate panel)

Regards,
Ajay Mishra

9

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