I have two excel files
mapping customer code excel
master customer code excel
What i want to do is read 1st mapping excel (column C and column E) and then write cell in 2nd excel (column B) where site codes are matching with looping.
Let me know any suggestion for this case. Many thanks for your help.
can you share expected output
@Htwe_Ko_Ko_Wynn, Here is a high approach.
Step 1: Use Read Range activity and capture the output in DataTable variable (e.g. dt_Customer)
Step 2: Loop through excel rows. (Use For Each loop within Excel Application Scope)
Step 3: Use Read Cell activity to get site code value in string variable. (e.g. siteCode)
Step 4: Use Write Cell activity and assign value as: dt_Customer.Select(“CityMard Customer Code=’” + siteCode + "’)(0)(“SAP Customer Code”).ToString
Hope it helps.
This is my expected output bro
You can use VlookUp formula in write cell and then using autofill u will get all data for SAP Customer
Let me try your solution. thanks bro
I tired your solution, however, i got some misunderstanding and i would like you to check my xaml if you have time
test2.xaml (10.4 KB)
Sitecode test.xlsx (9.0 KB)
sitecode mapping.xlsx (7.9 KB)
test2.xaml (9.6 KB)
You can simply use
LookUp Datatable activity inside for each row activity.
using lookup datatable activity you can search for a value in datatable and returns value from another column.
Check out this example…
You can use Lookup DataTable activity here,
you have max bill month stored in “LastMonth” variable.
So parameters of lookup datatable should be,
Datatable —> datatable variable
Lookup Value —> LastMonth variable
Lookup Column :-
ColumnName —> “Bill Month”
CellValue —> create system.double variable here(to store Actual balance amt)
Target Column :-
ColumnName —> “Actual Balance Amt”
So that’s h…
Many thanks for your second time help Bhavik.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.