Adding additional details in Excel usking vlookup

Help Activities
,
1

In this code the bot is downloading the excel file from SAP and as we can see in Figure one for certain “Billing Document” the value of Bill documents remain same but GT invoice changes
So currently bot is picking up one GT invoice value only but requirements is that it pics multiple GT invoice example Figure 2.

Figure 1 Figure 2|666x500
Figure 1 Figure 2|666x5001920×2560 799 KB

It’s using vlookup activity to get GT invoice number.

2

Hello,

Are you want to get all “GT” values based on “billing document”?

3

yes i want all the GT invoice no for same Billing Document , those who contain single invoice as well as multiple one

4

First get all the “Billing document” column values without duplicates using datatable.DefaultView.ToTable(True,“Column Name”).loop through each billing document and use filter datatable activity to get all the Gt invoice number corresponding to the billing document