Filter Data table of players

[Olek1 (Olek)]

Hello guys!

I have data like this:

1,Alex,–,W W

W

W

W

2,Donald,–,W

L

W

W

W

W

W

L

3,Taras,–,L

W

L
4,Iuliia,–,W

L

W

L

And I need to filter this players and add queue only for players who have two “W” and more…
Please help me to filter

[pattyricarte (Patty Boy)]

What type of format are these csv,excel or datatable ?

cheers

Happy learning

[sarathi125 (Parthasarathi)]

@Olek1,

I assumed that you are getting this string from a text file and split it using Regex and counted the W and written the player name, Place the text file on your desktop and check the attached workflow. Let me know in case of issues.

SplitStringByNumbers.xaml (6.9 KB) players.txt (132 Bytes)

[Olek1 (Olek)]

I used data scraping, It is Data Table…

[pattyricarte (Patty Boy)]

Do you have a header?

@Olek1

[Olek1 (Olek)]

YYes

[pattyricarte (Patty Boy)]

Can you write it in excel so that we can easily read the structure of data.then from that we can come up for the flow

[Olek1 (Olek)]

New Microsoft Excel Worksheet.xlsx (7.3 KB)

This is my datatable in excel

[pattyricarte (Patty Boy)]

Ok I will check it

cheers

Happy learning

[pattyricarte (Patty Boy)]

Ah i see you don’t have any header @Olek1

[Olek1 (Olek)]

yes, sorry I thinked that I have…Can you help me with this without header?

[pattyricarte (Patty Boy)]

i will try it,By the way do you want to filter the player with multiple “W” am i ryt ?

@Olek1

cheers

Happy learning

[Olek1 (Olek)]

yes, I need to get only players name who has two “W” and more

[Luis261980 (Luis Nunes)]

Hi @Olek1,

Try this

testPlayers.xaml (11.2 KB)

GL with your project.

[pattyricarte (Patty Boy)]

Hi @Olek1

Kindly see attached code below for your reference.

Olek1.zip (14.3 KB)

cheers

Happy learning