Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Thanks,
Sunil
Thanks Sunil, this worked:
where
left(Store_Desc,3)<>'(C)'
and
left(Store_Desc,3)<>'(c)'
Thanks,
Sunil
try this
Load
f1
f2
.
.
from path where left(StoreName,1)<>'C';
hope this helps
Thanks Sunil, this worked:
where
left(Store_Desc,3)<>'(C)'
and
left(Store_Desc,3)<>'(c)'
Thanks,
Sunil
no need to write two times
where
left(upper(Store_Desc),3)<>'(C)';
this will also server the purpose.