Lookup Datatable (Showing in the Excel Column)

Help Activities
,
1

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

2

Appreciate someone can help on this. Thanks

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

3

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

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

4

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.

5

@ack940129

Check as below

image
image1040×727 23.8 KB

test.zip (23.2 KB)

Hope this may helps you

Thanks

1 Like
6

Hi @Srini84,

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)

7

@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
8

Hi @Srini84

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

9

@Srini84

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.