Column Filter Based on Value of another column in separate input

[hemant86]

Hi All,

I have my filter values coming from another input. I need to pickup these values and apply filter in another Table. Now I am able to achieve this through join since my LCODE(Input for Filter) will not have any duplicates. Just checking if there is an alternative to achieve this other than JOIN. Please see sample below. Thanks in advance.

Input for Filter:

LCODE

123

345

456

678

789

Table To apply Filter on:

EMPID	LCODE
1	123
2	345
3	123
4	456
5	123
6	456
7	456
8	345
9	100
10	200
1	123

Expected OUTPT:

EMPID	LCODE
1	123
3	123
5	123
1	123
2	345
8	345
4	456
6	456
7	456

[binuacs · Accepted solution]

@hemant86 One way of doing this with the batch macro

[hemant86]

Thanks @binuacs This works perfect.!