If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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: [vProfileB12]
And i know inside there is just raw data : [ 1,5,4,8,3,...,]
I tried subfield(vProfileB12, ',') But still geting some error
Any hint ?
LOAD Product,Subfield(Value,';') as Value,'Value_sales_period'&AutoNumber(RowNo(),Product) as Period
Generic LOAD Product,Period,Value
Drop Table Temp;
HI thanks for the hint! .. But there are still some things i wonder.
The name of the Array field i try to get is [vProfileB12], i just have 50 values describing a profil . You load 3 "items" , PRODUCT, PERIOD and VALUE. And i work with only the Array's Name: i guess my Array's name correspond to your "VALUE" but for PRODUCT and PERIOD i don't get it.
More over i don't have any value to copy from anywhere, how do i get with :
A,1;2;3;4;5;6;7;8;9;10;11;12 ===> ( up to 50 for me ?)
even tho its calculated , the " Value_Sales_periode' and AutoNumber(RowNo(),Product) doesn't mean anything to me so i kinda wonder whats is it for and where does it come from
vProfileB12,Subfield(ArrayValues,';') as ArrayValues
Drop Table Temp;
I'm getting still the same error,
I'm getting this array from a data base maybe it has to come from something like this .
the only array line i add make the whole loading script not loading.
But still concerning your arrayValue: A,1,2,3,4,5,6,7,8,9,10... i don't know what it means ? is it the value i'm suppose to get , is it "indexation" or something like that.
Inline is the way to show the logic not to use it later on as a solution.
Delete the part of my code from your script.
Just load your table, with new field called what ever you want to call it, I called it ArrayValues(just as an example- but you can go with it). And use this logic to create it:
Subfield(NameOfTheFieldThatGetsAsAnArrayFromDB,'sign that separates the elements in the array') as ArrayValues
HO ok ! your first explanations kinda troubled me...
i understand subfield() but i never used INLINE, my bad
i feel like i miss a basic knowledge in load statement as if the order or the placement of the instruction are wrong.. : i make it the basic -est possible but still get the same error
i try to turn it around in every way i usually use to get things working, but still that same error ...
what do i miss ??