USING STUDIO X, HOW TO FILTER THEN COPY

Hi, i really need help. IM Using studi x community
in my manual using excel, i have a table where it contain 3 column Product, RM, BM,
then i want to filter column Product and choose only D, then i will copy all column BM into RM

BEFORE

Product RM BM
A 30 45
B 49 8
C 45 9
D 70 76
E 67 8
F 89 9
A 6 1
B 7 2
D 8 4
D 90 6
F 5 89
D 43 6
D 6 47
G 8 8

AFTER

Product RM BM
A 30 45
B 49 8
C 45 9
D 76 76
E 4 8
F 6 9
A 6 1
B 47 2
D 4 4
D 6 6
F 5 89
D 6 6
D 47 47
G 8 8

Hi @Nur_Amin

Please find the below screenshot and the xaml file
image


Main.xaml (19.9 KB)

Hope it helps!!

Hi @Nur_Amin

Use for each to iterate through excel:
if(CurrentRow("Product").ToString.Contains("D")):
Then 
Pass in Write Cell: CurrentRow("RM").ToString 
            CurrentRow("BM").ToString

hi , can i see the full for condition?

@Nur_Amin
Put For Each over DataTable
Use If Condition
->Row(“Product”).ToString.Equals(“D”)
Then-> Use Assign activity
Row(“RM”)=Row(“BM”).Tostring

@Nur_Amin

I have attached a xaml with completed process and you can access that too

In write cell activity please use the below syntax and also keep the auto increment true.

Where to write

What to write

Regards

THANk you so much. appreciate it

Thank you @Nur_Amin

Happy Automation!!

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