I guess there is no other such function. Having said that, if you can describe your real scenario, may be, you could be helped. There are options of using loop in the load. Most likely, you can look into While clause, that lets you read the same record repeatedly until a certain condition is met.
mid(Grades,IterNo( ),1) as Grade,
pick(IterNo( ), 'Math', 'English', 'Science', 'History') as
Subject from Tab1.csv
while mid(Grades,IterNo( ),1)<>' ';
Hi guys, and thanks for the quick replies!
I thought I'd spare people having to read about my actual scenario, as it is quite complex but as you may suspect I am trying to avoid loops.
Loosely speaking I have an application which evaluates each fact table input row, and sometimes (but but far from always) has to create more than one output row for each input row. A for-loop would likely be much too slow for my purpose. I haven't checked while loops, but it's worth a try.
Anyway, subfield being the only function of its kind is useful information, so many thanks!