Excel data query compr

[Palaniyappan (Forum Leader)]

You were good so far
Please find the above steps buddy
Kindly let know for any queries or clarification
Cheers @balkishan

[balkishan (Balkishan Singh)]

sure bro, I am implementing it. Thanks for your good response

[Palaniyappan (Forum Leader)]

Yah fine
First assign activity where we are getting the file array as output which is the files in the PO folder
That’s what I mentioned as Alone buddy and as out_POfiles and before to this assign Use another assign activity and mention as
Out_TAXFilepath = “yourfolderpath/“

Which will have till last Folder path except the file name that’s why mentioned even with forward slash here “yourfolderpath/“ to concatenated the Filename alone similar to that we open now in the excel application scope (from PO folder)

Because our intention is to open same file from both folder
Then these steps buddy
@balkishan

@Palaniyappan

—name that array variable as out_POfiles
—now use a for each loop and pass the above variable as input and inside the loop use. Excel application scope and pass as item as input
—inside that scope use a read range and get the output with a variable of datatable named dt1
—while still being inside the for each loop now use another excel application scope next to this scope and mention as
In_TAXFilepath+Split(item,”/“)(Split(item,”/“).Length-1)
Where we will be getting the output as dt2
I would prefer to go for these steps because you want to make an update with a new column

[Palaniyappan (Forum Leader)]

Did that work buddy
Cheers @balkishan

[balkishan (Balkishan Singh)]

Doing bro…will let you know

Bro, There should be a backward slash in the out_TaxFiles

[Palaniyappan (Forum Leader)]

Yah exactly
Cheers @balkishan

[balkishan (Balkishan Singh)]

Yes bro, Till it’s working fine. I have data in two datatypes variable for PO and Tax.
Please tell me the further process. What I have to do.

[Palaniyappan (Forum Leader)]

Fantastic
Next these

@Palaniyappan

—now create a datatable with build datatable with same set of columns but with extra column status and get the output as Finaldt

—now use for each row and lass the first datatble dt1 as input
Inside the loop use a if condition and mention like this
row(“yourcolumnname”).ToString.Equals(dt2.Rows(dt1.Rows.IndexOf(row)(“yourcolumnname”))

—if true it will go to true part where we can use a add data row and in the array row property mention as {row(0),row(1),row(2),…,”Yes”}
And in the datatable mention as Finaldt

Cheers @balkishan

[balkishan (Balkishan Singh)]

@Palaniyappan

now create a datatable with build datatable with same set of columns but with extra column status and get the output as Finaldt

For the extra column value I want to update in the another new excel file bro.

[balkishan (Balkishan Singh)]

@Palaniyappan

row(“yourcolumnname”).ToString.Equals(dt2.Rows(dt1.Rows.IndexOf(row)(“yourcolumnname”))

This you have used for one Column Name bro, I have five columns bro.
Got this error bro

[Palaniyappan (Forum Leader)]

Sorry for the delayed response
No worries
Same with AND operator in between each condition with different column name
Cheers @balkishan

[balkishan (Balkishan Singh)]

I did that but later on removed, But I am unable to removed this error.

Please see bro

[Palaniyappan (Forum Leader)]

We need one more close bracket )
At the end
Cheers @balkishan

[balkishan (Balkishan Singh)]

Please help to rectify this error bro.

@HareeshMR please help to resolve this issue.

[Palaniyappan (Forum Leader)]

Ah got it
I will tell for one column kindly follow the same or the rest as well

@Palaniyappan

row(“yourcolumnname”).ToString.Equals(dt2.Rows(dt1.Rows.IndexOf(row)(“yourcolumnname”))

We didn’t mention the row index inside the row argument
Cheers @balkishan

[balkishan (Balkishan Singh)]

see same error showing, I did for all bro.

[balkishan (Balkishan Singh)]

Okay if we’re able to remove for this we can remove for all.

didn’t get where I have to mention the RowIndex bro ?

[Palaniyappan (Forum Leader)]

Fine
It should be like
row(“yourcolumnname”).ToString.Equals(dt2.Rows(dt1.Rows.IndexOf(row))(“yourcolumnname”))

Sorry it was my mistake
Cheers @balkishan

[balkishan (Balkishan Singh)]

No problem bro, now this error is gone.

[Palaniyappan (Forum Leader)]

Fantastic
Is it working buddy
Cheers @balkishan