Issue with Append Rage

[anon40731888]

Hello I have a problem with Appending Range,

I have 2 sheets in excel, and I want to move all rows if age = 30 to Sheet = 2 so this is what I want to have:

My sheet 1 is:

And I want my sheet 2 to be:

But instead whatis happening is:

Sheet 1:

Sheet 2:

Why is that?

Any ideas?

[prateek.mehandiratta9 (Prateek Mehandiratta)]

Hi @anon40731888

Use filter datatable to remove blank rows:

Thanks.

[anon40731888]

I know I know, but I’m wondering why does it work like this? shouldn’t this append the data to rows: 2 3 4 5 6 ? (excluding header?)

[prateek.mehandiratta9 (Prateek Mehandiratta)]

Hi,

Is it possible to send your xaml so i can check whats wrong.

[Anil_G (Anil Gorthi)]

@anon40731888

Try deleting the rows 2 and 3 by selecting whole row once…may be there is some blank value or formatting…which is making the bot to append from 4 instead of 2

Also if that is not the case…please show what is the value you have for append after range property

Cheers

[anon40731888]

I don’t think its that for example: if I want to append position 7 and 8 from sheet 1 it will be appended to position 7 and 8 from sheet 2, if I want to append position 2 and 3 then it will show on 2 and 3 on sheet 2 (if sheet 2 is empty)

[Anil_G (Anil Gorthi)]

@anon40731888

the first one will append after the filled data

the second one will append the data as per the range you provide…if you provide whole sheet then it will append as per the first empty cell. you would have provided range so it appended as per range…remove range and give only sheet and check

cheers

[pravallikapaluri]

Hi @anon40731888

Here is the Xaml With the expected output using Excel activities (Filter and Append range),Check it out
BlankProcess3.zip (395.8 KB)

Hope it helps!!

[anon40731888]

I made a new excel file so the formatting was new and used read range + write data table and it works now