So as the above shows, the Key ID of 1 has 3 subsidiary ID's of 2,3 & 4.Col1, Col2
1,3
1,4
1,5
2,6
2,7
2,8
In my Job I want to pass the Key ID into the Hash File and bring back all the subsidiary ID's for that Key ID. At the moment, I am only managing to bring back 1 subsidiary ID.
Any ideas on how I can bring them all back ?
Cheers
Jez T