Filter another activity in the loop

Help StudioX
1

Screenshot_20230220_123154_Chrome
Screenshot_20230220_123154_Chrome1080Ă—2316 193 KB

I wan to filter another column and carry on the same using for row. I have done the above. Can i do it inside the loop to filter another column?

2

Hi @Mark_Rajkumar

can you add the filter you want within the same filder datatable activity?

3

Hi @Mark_Rajkumar

To filter another column you can add that column in the Filterdatatable you used

Click on Config Filter and then click on add button and then add the other column there

use And (or) Or based on your requirement
image

Regards
Sudharsan

4

Hi @Sudharsan_Ka and @fernando_zuluaga , i have added an additional variable to read a specific column in the datatable if u look at the workflow. I want to add another column but its not performing the activities which it did earlier.

5

@Anil_G ur inputs

6

@Mark_Rajkumar In That assign Activity

newDT

dt.DefaultView.ToTable(true,"Column1","Column2")

After that inside for each try like this

Regards
Sudharsan

7

@Mark_Rajkumar

What do you mean by another filter?

Where you want to add and what is that you are trying to acheive…can you show some inputs and outputs

Or explain the process about what is done and what is to be included yet

Cheers

8

Hi @Sudharsan_Ka, by adding in the rest activities is not being achieved

9

@Anil_G

  1. Read range the data into datatable and name is dt.
  2. Use save for later to create a variable called newdt where the value dt.DefaultView.ToTable(True,“Names”)
    3.For each row, use newdt as output,
    4.filter datatable inside for each row keeping column name and the operations value as currentrow(0).Tostring with output as filterdt
    5.write filterdt in new sheet.

This is the process. However in the new sheet I wan to do the same for another column. How do i achieve it? I tried in the loop the results are wrong.

10

@Mark_Rajkumar

So you want to take the unique again and then filter and then add it?

So you want to get unique bades on teo columsn at once ? If so then use dt.DefaultView.ToTable(True,“Names”,”column2”)

Or if you want to do this one after the other then repeat the zame steps agin with required columns

Cheers

11

@Anil_G i wan to put into 2 names in the column but how to achieve it? It is not going right

12

@Mark_Rajkumar

This is how you fo for two columns together

Cheers

13

@Anil_G i got that but with that how to filter the values?

14

Sharing Sample input and expected Output will be better ,Can you please share it?@Mark_Rajkumar

15

@Mark_Rajkumar

Like this

image

Cheers

16

You have already used a filter datatable inside for each @Mark_Rajkumar

You just need to add new condition in the filter wizard as i said earlier

Regards
Sudharsan

17

@Anil_G the filter values is the same as currentrow(0).ToString for both column? When i am doing this the filter is not being performed

18

@Sudharsan_Ka i have done the same but it is skipping steps by not performing any activities

19

@Mark_Rajkumar

Now you have two columns…first column will have 0 index second will have 1 index so use currentrow(1).Tostring for second column

Cheers

20

If it skips the whole for each row activity you need to check whether the datatable is returning any values or not @Mark_Rajkumar