You can translate the question and the replies:

Get first element from an array field in a view, built with a Denodo custom function.

I have an array that has been created by a Denodo custom function that stores parsed ID numbers from 2 string fields concatenated; parsed_id. The field shows as an array in the view. I am trying to get the first element of the array and have tried, parsed_id[0].VALUE as shown in an answer to a question I posted earlier, 'working with arrays', but its not working. Thank you
16-01-2015 00:21:32 -0500

1 Answer

Hi, According to your description of your scenario, I am afraid it could be difficult to reproduce your scenario to make a diagnosis. Maybe the array is not created appropriately. You can try to use parsed_id[0].parsed_id instead of parsed_id[0].value. If you or your company have a support user, it would be easier to help you if you open a support case attaching the VQL of your view in order to drill down this scenario. Regards!
Denodo Team
16-01-2015 04:53:46 -0500
You must sign in to add an answer. If you do not have an account, you can register here