Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.