Filter DT case

Help
1

Hi All,

What is my case.
In excel Sheet1 I have a column with names and roles assigned to each
I want to filter each row and leave in second column only role which is not on the list in Sheet2
Finally I want to have a DT as in sheet Results

Example1.xlsx (10.6 KB)

Thank you

2

here you go
hope is resolved
nite.zip (11.7 KB)

Cheers @niteckam

3

Hi,

I’m not sure it works. This is the final DT
121

4

yah exactly it matches with your requirement
image

where in the screenshot of the output panel been attached by you
has the same (highlighted one is the NAME having each roles)
image

you can remove the output dattable activity and the writeline activity and directly use WRITE RANGE activity with the datatable dt_final as input so that it will be written in a excel

Cheers @niteckam

5

Hi

Tere was a small mistake in 1 of the split method. For both sheet1 and sheet2 we have ‘;’ between roles instead of ‘,’
Look I should not have anymore in output DT LINE MANAGER or PROCESS CREATEOR

6

sorry i didnt get that
come again pls
@niteckam

7

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

9

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