Lookup Datatable (Showing in the Excel Column)

Hi All,

I’m trying to use lookup datatable to get the Excel file column data and insert into another Excel file column, I’m able to get the value but the value always not showing in the correct column. I have attached the file as below. Appreciate your help on this issue. Thanks.

Main.xaml (9.3 KB) project.json (938 Bytes)

test0.xlsx (8.4 KB) test1.xlsx (12.8 KB)

Example as below:
If 1st excel’s Order No. = 2nd excel’s OrderNo1 and 1st excel’s itemNo = 2nd excel’s itemNo1
then get the “Position No” and insert into 1st excel.

I got the Position No but always show in the column not I want as below.
image

This is the result I want to show in my 1st Excel.
image

Appreciate someone can help on this. Thanks

Hi Both Expect, not sure if you guys know about this or not.
@ksrinu070184 @Parth_Doshi

Main.xaml (9.6 KB) project.json (938 Bytes)

Hi All,
Please ignore the file above, use these files instead. Thanks.

Hi All,

image Main.xaml (9.6 KB) project.json (938 Bytes)

I’m able to input to the correct column now, but not sure why I always get the same data as below screenshot.

@ack940129

Check as below

test.zip (23.2 KB)

Hope this may helps you

Thanks

1 Like

Hi @ksrinu070184,

This is work nicely for the testing data, but when it come to the real data as below. It’s not showing there. please assist. Thanks.

Main (1).xaml (18.2 KB) project.json (938 Bytes)
Completed_1st.xlsx (11.9 KB) Completed_2.xlsx (25.7 KB)

@ack940129

In IF condition make tempDB.Rows.Count > 0

image

Here the item no is same so you will get the same number

Hope this helps you

Thanks

1 Like

Hi @ksrinu070184

How can i avoid getting the same number ya? Thanks.

@ksrinu070184

I have tried other way but unable to get the result i need, do you know how to getting the result but not same number? Thanks.

This activity enables you to search for a provided value in a specified DataTable and returns the RowIndex at which it was found. This activity can also help you return the value found in the cell that has the row coordinates specified in the RowIndex property and the column coordinates specified in the Target Column property category. For more info. Click Here