Filtering the DataTable giving incomplete data. Using row of one data table for filtering the data of another data table

Help
1

@ALL

Hello Guys

I am using one data table to filter another Data table, but i am getting incomplete data.

Right side is complete data and left side is incomplete.

image
image1366Ă—519 55.9 KB

Below is the workflow screenshots

image
image692Ă—483 14.8 KB

Please check the workflow. Sharing the excel sheet also in sometime.

TestSeq.zip (3.9 KB)

AP consolidated File.XLSX (174.2 KB) AP Vendor List.xlsx (11.2 KB)

I am using the AP vendor List to Filter the AP consolidated file based on vendors and sheet. Please check the excel.

Can anyone help me?

2

Anyone??

3

@AryanSingh Hi,
Try this workflow. I’ve changed the file paths, please make the necessary changes.TestSeq.xaml (28.8 KB)

4

@shibani

It is giving the similar results.

image
image1329Ă—320 13.1 KB

5

@AryanSingh final.xlsx (123.4 KB) This is how i’m getting the output. This is how you want it right ?

6

@shibani

no please check the query sceenshot, i have mentioned that the data it is giving out after being filtered is incomplete.

for eg: check the data for **vendor “211709”**in both consolidated and final sheet. both are different.

1 Like
8

@Palaniyappan
@shibani

Please check the screenshot below. Right side is Consolidated sheet n the left side is the final sheet. I have filtered according to the vendor 211709. Please check both the left excel and right excel.

image

@Palaniyappan

Please help me with this.

1 Like
9

fantastic
i got the issue
few more mins
@AryanSingh

1 Like
10

@AryanSingh
TestSeq.xaml (28.7 KB)
Try this

11

@Palaniyappan

Thanks.

@shibani

Let me check. Thank You.

12

here you go
its resolved
aryan.zip (264.8 KB)

Cheers @AryanSingh

1 Like
13

@Palaniyappan

I am getting this error when running the workflow after the update. I don’t know why!

image
image820Ă—311 13.7 KB

Please help me.

14

@Palaniyappan

Let me check and see what I was doing wrong. Thanks

15

@Palaniyappan

Can you please explain what the issue was and why did we need to clone the data table and steps?

Hope you won’t mind.

Thank You for the solution.

1 Like
16

The reason was we were iterating through vendor Dt. Records and not on consolidated dt records
That’s why based on the number records in vendor dt it was giving us only that number of records
So here in this process we are iterating through consolidated dt
So it gave us full records
Cheers @AryanSingh

1 Like
17

@Palaniyappan

Thanks. Now I get it.

1 Like
18

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