Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
employe4_2
Contributor III
Contributor III

Load Array data from data base

Hi,

 

I'm trying to load some data from a database and some fields are array type. And from this point i cant load anymore. I looked for some solution, to load array types but i cant get it.

All i have access is : the name of the ArrayField

And i know inside there is just raw data :  [ 1,5,4,8,3,...,]

Any hint on this one ?

Labels (1)
3 Replies
miskinmaz
Creator III
Creator III

use subfield function like

subfield(FieldName,',')

 

employe4_2
Contributor III
Contributor III
Author

Hi , 

still the same error, 

2019-09-27_13h41_30.png

  

2019-09-27_13h41_09.png

tried other combination and nothing seems to workout. Could that be  a problem with the database? i already extract data from it, but not array 

miskinmaz
Creator III
Creator III

I am not sure but try to pull the table again. And if this is successful then try to use the subfield through a resident load.