Updating the status

Help
1

Hi, I am done with the workflow, Where I am comparing the data.
At Last I want to update the status in the New Excel Like
If data match in both the Excel then write the status Matched if not then Not Matched.
One more column for CustomerName.
I already have this variable with dynamic name
image

I created the Build Data Table,
with CustomerName and Status headers and store in a NewDT variable.

can you please tell me what I have to mention in the Add Data Row activity.
In the Status I can mention Match and Not Match in the Then & Else part of IF condition.
But how I mention this variable which contain my dynamic Customer Name.

Followed the approach.

image
image824Ă—495 13.6 KB

@Palaniyappan @lakshman @Lahiru.Fernando @indra

1 Like
2

@balkishan

You can do it in two ways.

  1. Read Index of that row and use Write cell activity and pass status to it.
  2. Other way is to assign status like below.
    row(“Status”) = “Matched/Unmatched”

And at last use Write Range activity to write all processed rows status into excel file.

1 Like
3

@balkishan For this case add data row is not required you can use write cell activity

1 Like
4

Thanks Lakshman,

Now it’s done. But there is an issue. I will show you
My approach

image
image617Ă—507 10.7 KB

Now see when it Matching the first file. It write the correct status with the Customer Name.
image

When It check for second file it removed the previous updated record and write the Headers two times.
now it gives me this…
image

1 Like
5

How bro, please tell me how can I do this.

6

How I am approaching…

image
image597Ă—517 11.9 KB

7

Hi Lakshman, can you please tell me how to mention in the Then & Else part of the Write Range Activity.

8

@balkishan

  1. assign Int count =2
  2. in if condition
    if
    {
    //True
    Write cell activity pass range with ”B”+count.tostring with value match
    }
    Else
    {
    //False

Write cell activity pass range with ”B”+count.tostring with value unmatch
}

3.Increment count =count +1

1 Like
9

But how I mention here Match/ Non Match

I have to pass the row(“CustomerName”) variable also. bcz it’s containing the name.
OR

I have used Name folder also where I have the same valuedynamically coming from CustomerName row.

SO first I want to write the Headers then from A2 data.
Like this.
image

10

@balkishan Outside if condition assign variable and pass the dynamic value and inside if condition use write cell activity and pass range with ”A”+count.tostring with variable assigned outside the if condition

1 Like
11

Bro, This I already done. But you suggest me not require Add data table.
Now I want to pass the two value.
First for CustomerName either by using row(“CustomerName”) or by Cust_Name bcz same dynamically value coming from the CustomerName into the Cust_Name.

Second I want to pass the Match/Not Match in the B cell.

I already created the Build Data Table with headers Customer Name and Status.

Can you please tell me in the Then & Else part what I have to do.

12

sorry bro, I didn’t get this.

you mean to use two diff Write Range Activity in Then and Else part with using the same excel.
can you show me how I mention these values in the Write Range.

13

@balkishan Not write range you needs to use two write cell in if and else condition

1 Like
14

Okay bro,
see is it a right way to mention

image
image799Ă—464 17.2 KB

How to mention Match here

16

@balkishan Can you attach your xaml file

1 Like
17

shared bro in message

18

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