Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm currently trying to dynamically convert the contents of an array field into a table. What's the best way to handle this in my load script?
The data looks like this:
DocumentID | Values |
123 | "AA","BB","CC" |
124 | "CC","BB" |
and I'm trying to convert it to this:
DocumentID | Values |
123 | AA |
123 | BB |
123 | CC |
124 | CC |
124 | BB |
Thanks for your help.
Subfield(Values,',') will split based on a comma separator. You can use PurgeChar(Values,'"') to remove the quotes if you don't want them to be part of the separated string.
Thank you! This is exactly what I was looking for.