Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How would I get data to show in the same format as the source data for values that begin with one or more zeros? for example:
invoice numbers, which are alpha numeric, when they start with 0 they are being shown as 2308 instead of 002308, i.e. the zeros at the beginnning are not showing.
How would I format the data to show these please?
I have tried the TEXT(VALUE) as VALUE option but this made no difference.
Thanks.
text(<your field>)
Hi,
try below
LOAD
Text(FIELD) as FIELD;
SQL SELECT
FIELD
FROM DBTABLE;
Regards
ASHFAQ