Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, is it possible to simplify this code, using iteration?
[Split]:
DECLARE FIELD DEFINITION
FIELDS
SubField($1, '/', 1) as [Part1],
SubField($1, '/', 2) as [Part2],
SubField($1, '/', 3) as [Part3],
SubField($1, '/', 4) as [Part4],
SubField($1, '/', 5) as [Part5],
SubField($1, '/', 6) as [Part6],
;
No. And you should almost never resort to iteration through tables. It will be sooooo much slower than doing thing inside the LOAD statement.