Need your help to create a Dynamic Sort Card.
My scenario like below.
The input file contains multiple employee numbers just below (This input file numbers can be decreased or increased depends upon the output created in the previous steps).
Employee number:
1001
1002
1003
1004
The output should be like below format.
SORT FIELDS=COPY
INCLUDE COND=((1,4,PD,EQ,1001), AND,
(1,4,PD,EQ,1002), AND,
(1,4,PD,EQ,1003), AND,
(1,4,PD,EQ,1004))
1.Please use code tags
2.At this moment I see a space before AND thats an error might be due to lack of code tag
3.Also Your condition is not going to work due to two reasons AND should be replaced by OR and PD should be replaced by ZD
4.Also in this case you might not need a dynamic sort card but just could use JOINKEYS(It depends on the size of the input file)
Could you let us know what could be the size of the input file?
Please clarify on your requirment and get back to us if you have any more questions someone will be happy to help you