Append range based on Excel Filter without results

Help StudioX
,
1

Hi Guys,

I’m facing some difficulties using excel filter, because the filter does not retrieve data (which is ok because I could have scenarios without results), but the idea is to append that result in another sheet and the bot is taking all the data without checking the filter applied (bot should not append if there is not results to append).

For example I have these two tabs
image

append sheet has this data
image

data_to_append has this other data
image

When I apply the filter to remove N/A from the data, the sheet looks like this
image

But when the append action is call it pastes the whole data into the data_to_append sheet.
image

Have any of you seem this issue?

I tried using a last row function to add an if validation but is retrieving 2(not really sure why).

I appreciate all the help!

2

Read Range into a datatable. Filter Data Table to get rid of the rows you don’t want. Append Range to the other file.

3

I’m a bit familiar with Studio, but currently I’m developing this on Studio X, do you know how to replicate this with available activities on Studio X?

4

I’m sorry, I missed that you’re in StudioX. I think the same process can be done but the activities might be slightly different.

This will cover reading Excel files and other common operations.

You still have the Filter Data Table activity in StudioX. Here is a thread for a very similar question:

5

Thanks, but in thread they keep explaining how to create the functionality using Studio and all the activities in it, nothing related to Studio X activities.

I tried to check Excel activities documentation, but I could not find nothing related to this issue that I mentioned.

6

They literally say StudioX, not Studio.

7

You were right Paul, my apologies, the issue was my UiPath Studio X version, it was from 2021. This is what I did.

  1. Filter the sheet, instead of using the data table filter, because it takes too much for me
  2. Read range activity by selecting Headers and show visible rows checks
  3. Use append range from developer app integration options using the read range output variable.

Thanks for the help!

8

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