Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day,
Has anyone created a field with an array of values?
Below is script that demonstrates what I'm trying to achieve.
The desired output is for [Inner Table] to have the following:
Inner Code | Inner Value |
---|---|
1 | A, B, C |
2 | D, E, F |
3 | G, H, I |
[Data_Table]:
load * inline [
Code, Value
1, A
1, B
1, C
2, D
2, E
2, F
3, G
3, H
3, I
];
For Each x in FieldValueList('Code')
Let vCurrentCode = $(x);
[Outer Table]:
LOAD
'$(x)' as "Outer Code"
AutoGenerate 1;
For Each y in FieldValueList('Code')
Let ConcatenatedValue = ConcatenatedValue & ' ' & Peek('Value',y,'Data_Table') & ',';
[Inner Table]:
LOAD
'$(x)' as "Inner Code",
'$(ConcatenatedValue)' AS "Inner Value"
AutoGenerate 1
Where
$(x) = $(vCurrentCode);
Let content = Null;
Next y
Next x
Hi Jagan,
SubField would work if I was going the other way.
max dreamer solved it in a QlikView discussion.
For anyone reading this later and wondering what the solution was, you can find it here:
Hi,
Try SubField() like this
LOAD
InnerCode,
SubField(InnerValue, ',') AS Value
FROm DataSource;
Regards,
jagan.
Hi Jagan,
SubField would work if I was going the other way.
max dreamer solved it in a QlikView discussion.
For anyone reading this later and wondering what the solution was, you can find it here:
Yes, I read it wrongly, you can do this by using Group by & Concat().
Regards,
jagan.