Page 2 of 2
Posted: Wed Jan 06, 2016 9:59 pm
by naveenkumar.ssn
vamsi_4a6 wrote:I have concatenated as mentioned below
Start,End,Start_End,End_Start,Distance
Bangalore,Mumbai,BangaloreMumbai,MumbaiBangalore,1500
Hyderabad,Delhi,HyderabadDelhi,DelhiHyderabad,2000
Delhi,Hyderabad,DelhiHyderabad,HyderabadDelhi,2000
Mumbai,Bangalore,MumbaiBangalore,BangaloreMumbai,1500
How to use above Start_End,End_Start columns for comparisions?
Hi,
Use the substring function to check whether the string exist in the column.
Regards
Naveen
Posted: Thu Jan 07, 2016 9:30 am
by chulett
chulett wrote:Your example doesn't seem to match up to your words. "1 out of 2 records" means what exactly - every other record? Every even? Every odd? Something else entirely? All your example shows are the first two records being 'selected'.
I don't know about anyone else but I for one would like to see this question put to bed, something that never was addressed. I don't see how anyone can expect a precise solution for a problem that can't be articulated... precisely.
