Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How is it possible to load values of some field on the backfront so that only the first 3 symbols could be loaded?
Thank you in advance,
Larisa
May be this:
Left(YourFieldName, 3)
You mean
Load(FieldName,3) as NewFieldName
My Mistake:
Updated:
Left(FieldName,3) as NewFieldName
FIRST 3 LOAD
*
FROM xyz.txt (txt);
Load the first 3 rows of the source