I want to solve the critical scenario

Help Studio
1

Hi,

I explain one scenario pls give me some suggestion.

  1. i generate one report yesterday i get pending amount customer id.
    (Example: ABC 10, XYZ 30, ZZZ 10 then i enter in dynamic ax)

2.i generate one report today i get pending amount customer id.
(Example: XYZ 30, ZZZ 10 then i enter in dynamic ax)

Customer ABC is paid pending amount so not there in today report now how to edit that padi employee is 0.

pls give me some suggestion to solve this issue

Regards,

2

Hello @MD_Farhan1!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

3

Hi @MD_Farhan1

Please check the attached xaml:
Sequence25.xaml (14.1 KB)

regards

1 Like
4

Now working bro .

Thank you for your helping. :+1:

1 Like
5

You’re welcome bro @MD_Farhan1

Happy Automation!!

1 Like
6

Hi Bro i need another one help bro. same way to check yesterday data and today data both column value is same in both data no need to copy else i want to copy and write a data.??? pls suggest the query

Thank you in advance.

Regards,

7

When data is same what do you wanted to write into the excel?

Can you please elobarate the query.

Regards

8

same procedure if same data no need to write the data
if not same amount write a data.

Example yesterday_Data 1)ABC - 1000, 2)XYZ - 2000, 3)ZZZ- 1500
Today_Data 1)ABC -1000, 2)XYZ -1000, 3)ZZZ- 1500.

above example i want only XYZ data only. if all same write empty table

9

So do you want to compare data with all columns@MD_Farhan1

Regards

10

in the file have only two column customer_id and amount

11

So I need to compare the both th columns right? @MD_Farhan1

Regards

12

yes bro customer id as per the amount column all so
compare

13

Hi @MD_Farhan1

Try with this linq query:

(From row1 In dt1
Where Not dt2.AsEnumerable().Any(Function(row2) row2("Column1").ToString().Equals(row1("Column1").ToString()) OrElse
row2("Column2").ToString().Equals(row1("Column2").ToString()))
Select row1).CopyToDataTable()

Regards

14

Bro above Query also return the same value as previous query.

15

Hi @MD_Farhan1

Use the below linq query:

(From row1 In dt1
Where Not dt2.AsEnumerable().Any(Function(row2) row2("pending amount").ToString().Equals(row1("pending amount").ToString()) AndAlso
row2("customer id").ToString().Equals(row1("customer id").ToString()))
Select row1).CopyToDataTable()

Regards

16

thank you bro working fine but data get from yesterday file. its fine i changed query to copy today file.

Thank You for your Patience

1 Like
17

Oky have you replaced therow1 with row2 at the only right? @MD_Farhan1

Regards

18

i change from frow row1 to from
row 2 that one is starting.

1 Like
19

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