I'm executing a google OSM call to for address validation. When I use the JSON PATH node to collect the elements of the adress, I have a column with the LIST datatype. Example [street,city,state,zip]. I need to loop through all the elements of that list column to perform operations. I could convert it to a string and then use the CELL SPLITTER node. However I will never be certain how many elements are in the list.
Is there a node to loop through a LIST datatype column? My only other alternative is to split the colum on the comma and then loop through all the potential columns generated. A bit of a pain to code around.