i am trying to create a call center dashboard. and i have to to display the abundant rate.. in my data set as i shown below i need to extract the numbers that i have marked from yellow. is there any possibility of doing this ..??
thanks in advance your help is greatly appreciated.
1. This are few numbers or there is large list
2. It is of same length in character like 4 or 5
If it is few then try to this in the load script with where exists or the Mapping table.
If possible provide the sample data
1) yes i have shown few from a very large list.. but most of the time same number repeats..
2) this displays a 4 digit number or a 9 digit number.
from this large list i need to extract the 4 digit numbers and a number that starts with 07102 from the whole list.
Then try to load data in load script this way
Where Left( [abundant rate], 5 ) = '07102' And Len( [abundant rate] ) = 9 or Len( [abundant rate] ) = 4;