Filter data

Help
1

Hello,

Any ide on how to remove the two first rows and the two last once?

I tried to use Filter Data, since i need only the once whish have numbers but wont work!

Also how to get the id table, since i can’t get it with data scraping table…

Any ideas? Thank you.

Mohssine

2

@mz3bel

Could you please tell me more details for better understanding.

What is your input type and how you want to delete it.

3

@lakshman

Ok, i have a table, that i have to extrat. The problem is that i that table i have delete the two first and the last two rows.

A.xlsx (9.1 KB)

Like what i have on this file, it’s a modified copy of the real one. So i need to remove the generic message.

I tried with Filter Data Wizard. No success

4

You can try with Filter Data Table and use the remove option , then you select the columns you want to filter, example:
[columnName] or index contains generic message
if you want to filter more columns just click the plus [+] button

filter
filter798×381 11.5 KB

Let me know if it works! Good Luck :smiley:

1 Like
5

Hope the attached example will help you. FilterData.zip (23.1 KB)

1 Like
6

Hi @mz3bel,

Use the below expression in assign statement and store the above expression in datatable

Datatable.Asenumerable.skip(2).take(datatable.rows.count-2-2).copytodatatable

Refer the below sample file and the EXAMPLE.xlsx (50.0 KB)
workflow

Flowchart1.xaml (9.4 KB)

1 Like
7

Already tried this way, it doesn’t work

8

Thank you!! It works!

9

Thank you, i followed the steps you’ve done and it works, at first it didn’t but figured out i had to make some small changes.

Thanks again!

10

Can you close the topic, if it works

1 Like
11

instead of “And”, must put “Or” and used the full names, because the messages contains diffrent words and lettres… Thanks for the help!

1 Like
12

Not yet i have a small issue that i mentioned before. How to add a name tag iside a web table so i can add it to my extracted data, i tried with tag but didn’t work. Can you help on that part too please?

Capture

13

Hi,

Can you provide more information what you are trying to achieve.

Based on my understanding, cant you extract the data first and add columns or data after that.

14

Hi,

Ok, i have a table on a dynamic web page, i used data scraping to get the data. But a column wont show it’s values, whish i need the name as mentioned in the previous picture. I need to add that name values to the data extracted.

I tried to change the selectors, but didn’t succed.

Thanks

15

Can I access the page where you are performing data scraping

16

Hi @mz3bel and @anil5

We can use “Get Attribute” activity to get the tag name of the UI Element/ control. Make sure that you set proper selector of the element (input element name tag in your case). Please refer the attached example.GetTagName.zip (10.1 KB)

Selector :

image
image1359×712 89 KB

It solves your purpose, please mark the post as resolved.

1 Like
17

No it’s not possible, because the it’s on local server.

18

I already tried this way, it didn’t work. The problem is that i use data scraping from a web table. I can get the column and all other data, but only the value of that column i can’t get it.

19

I solved my Column Value problem, i had to change the name of the attr in the meta.

20

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