Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wish to expand the Combis table to replace the delimited "Tec" and "Class" fields into individual rows.
Most of it can be done REALLY easily by saying (in the Combi load):
subfield (Tec, '|') as TecID // this will join it with the Tec table
subfield (Class, '|') as ClassID // this will join it with the Classes table
Any ideas how to expand/handle the Any (in Tec) and Any (in Class) ?
Thanks in advance
Alexis
Alexis
My proposal is rather a quick & dirty solution to the problem as I had very limited time to work on it. The complexity arises because the application is "wildcarding" 2 fields.
I would be very interested in seeing the results of anyone successfully optimising this script.
Regards
Jonathan
Hi Sivaraj,
I have taken your latest version and adapted it slightly to give me what I wanted (see attached).
Thank you once again for your help.
Best regards
Alexis
Thanks Henric - a very useful read!
Regards
Alexis