I would like to exclude data from my data set through the load script where the 'StoreName' contains '(C)' at the beggining.
How can i do this?
from path where left(StoreName,1)<>'C';
hope this helps
Thanks Sunil, this worked:
no need to write two times
this will also server the purpose.
Retrieving data ...