Quality Stage Project - sort issues with street name
Posted: Mon Jul 23, 2007 2:38 am
I'll try to describe the issue I have as much as I can.
I have job that used a Unijoin stage with an option exact match which is to GET STANDARDISED ADDRESSES LOADED
the problem I'm having is the order for one of the record in the output file ..
I'll put an example might help to understand the problem
0305084SA LESLIE AVE BLAIR ATHOL
9905065SA L'ESTRANGE ST GLENSIDE
0305074SA LESLIE AVE CAMPBELLTOWN
I would've expect the record the second record in the above group to be after the first record in the below group
0305062SA KYRE AVE KINGSWOOD
0305025SA LA PEROUSE AVE FLINDERS PARK
0305290SA LACHLAN CRES MOUNT GAMBIER
0305010SA LACHLAN ST FERRYDEN PARK
what I mean, I expect the output to be like the following
0305062SA KYRE AVE KINGSWOOD
9905065SA L'ESTRANGE ST GLENSIDE
0305025SA LA PEROUSE AVE FLINDERS PARK
0305290SA LACHLAN CRES MOUNT GAMBIER
This job is in a project which has been upgraded from Vality to Quality Stage. I got the result I'm expecting in Vality but when I upgraded to Quality stage and run the job I didn't get the same order for the street. obviously the QS is not considering the charachter " ' " preceeding the charcter "A"
Can any one please help me to solve this issue
Please let me know if you need to sumit more information .
Thanks
Ayah
I have job that used a Unijoin stage with an option exact match which is to GET STANDARDISED ADDRESSES LOADED
the problem I'm having is the order for one of the record in the output file ..
I'll put an example might help to understand the problem
0305084SA LESLIE AVE BLAIR ATHOL
9905065SA L'ESTRANGE ST GLENSIDE
0305074SA LESLIE AVE CAMPBELLTOWN
I would've expect the record the second record in the above group to be after the first record in the below group
0305062SA KYRE AVE KINGSWOOD
0305025SA LA PEROUSE AVE FLINDERS PARK
0305290SA LACHLAN CRES MOUNT GAMBIER
0305010SA LACHLAN ST FERRYDEN PARK
what I mean, I expect the output to be like the following
0305062SA KYRE AVE KINGSWOOD
9905065SA L'ESTRANGE ST GLENSIDE
0305025SA LA PEROUSE AVE FLINDERS PARK
0305290SA LACHLAN CRES MOUNT GAMBIER
This job is in a project which has been upgraded from Vality to Quality Stage. I got the result I'm expecting in Vality but when I upgraded to Quality stage and run the job I didn't get the same order for the street. obviously the QS is not considering the charachter " ' " preceeding the charcter "A"
Can any one please help me to solve this issue
Please let me know if you need to sumit more information .
Thanks
Ayah