View previous topic :: View next topic
|
Author |
Message |
Div Grad
New User
Joined: 08 Apr 2005 Posts: 45
|
|
|
|
I have a file of customer ids and dates those customers had service. I also have a file of when those same customers received a mailing. What I want to do is take that first file of customer ids and service dates and split it into two files:
- service that occurred before a mailing
- service that occurred after, or on, a mailing
So for example if I had this file of mailing dates for customers AA, BA, and CA:
Code: |
AA2017-03-15
BA2017-03-11
CA2017-03-21
|
and this file of customer service history:
Code: |
AA2017-03-05
AA2017-03-08
AA2017-03-15
AA2017-03-25
BA2017-03-04
BA2017-03-09
BA2017-03-12
BA2017-03-28
CA2017-03-07
CA2017-03-19
CA2017-03-22
CA2017-03-24
|
Then as output I would want two files. The first being this list of Customer Service dates that occurred before a customer received a mailing:
Code: |
AA2017-03-05
AA2017-03-08
BA2017-03-04
BA2017-03-09
CA2017-03-07
CA2017-03-19
|
and this list of service after, or day of, a mailing:
Code: |
AA2017-03-15
AA2017-03-25
BA2017-03-12
BA2017-03-28
CA2017-03-22
CA2017-03-24
|
Thanks in advance! |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2010 Location: USA
|
|
|
|
Code: |
JOINKEYS F1=...
JOINKEYS F2=...
REFORMAT FIELDS=...
SORT FIELDS=COPY
OUTFIL FNAMES=BEFORE,INCLUDE=...,BUILD=...
OUTFIL FNAMES=AFTER,INCLUDE=...,BUILD=...
END |
RTFM |
|
Back to top |
|
|
Div Grad
New User
Joined: 08 Apr 2005 Posts: 45
|
|
|
|
sergeyken - Thanks for the feedback, I got it now! I think I was trying to make it more difficult than needed. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2010 Location: USA
|
|
|
|
After JOINKEYS, the order of joined records is not guaranteed by SORT; it depends on the joining method actually used.
If specific order of final records is strictly required, then explicit SORT FILEDS=(...) might be needed. |
|
Back to top |
|
|
|