Hi
The data looks in a file looks like this
Acct_No Site
111 1000
111 1100
111 1200
111 1300
222 1100
222 1300
333 1300
444 1000
444 1300
555 1000
555 1100
I have to check if Acct_No exists in all the 4 sites 1000,1100,1200,1300 .
ex 111 is there in all Sites so I dont want this record in my out put file
222 doesn't exist in Sites 1000 and 1200 so my out put should have
222 1200
222 1000
so overall my Output file should look like this.
Acct_No Site
222 1000
222 1200
333 1100
333 1200
333 1000
444 1100
444 1200
555 1200
555 1300
Please suggest.
Help with logic
Moderators: chulett, rschirm, roy
Re: Help with logic
Hi Hope,
Though I dont have a solution, here is one suggestion. Creata an additional file (File B) containing 4 sites (1000, 1100, 1200, 1300). Make a full outer join between your source file (File A) and file B on the site and check the output which may help to get the required output by the using a filter/transformer.
Though I dont have a solution, here is one suggestion. Creata an additional file (File B) containing 4 sites (1000, 1100, 1200, 1300). Make a full outer join between your source file (File A) and file B on the site and check the output which may help to get the required output by the using a filter/transformer.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom