topic Re: Variables Values Generated Through Load Script in QlikView

Variables Values Generated Through Load Script

Wed, 09 Sep 2015 16:11:03 GMT

Hello!

I have value's field from which I want create variable values separated by comma.

For example, field with values "B","A","C","E","J". Variable = B,A,C,E,J

How can I get this through load script?

Thanks!

Colin-Albert — Wed, 09 Sep 2015 16:16:48 GMT

try something like this, it uses the ASCII codes for commas and double quotes.

Let Variable2 =chr(34) & replace(Variable, chr(44), chr(34)chr(44)chr(34) ) & chr(34) ;

maxgro — Wed, 09 Sep 2015 16:23:35 GMT

load * inline [

field

"a"

"b"

"c"

"d"

"e"

"f"

];

load concat(PurgeChar(field,'"'), ',') as newfield Resident a;

let var=Peek('newfield');

petter — Wed, 09 Sep 2015 16:27:53 GMT

This is an efficient way of doing it:

SomeValues: // JUST TO HAVE SOME TABLE/FIELD TO TEST IT AGAINST....

LOAD * INLINE [

Value

];

ConcatenatedValues:

LOAD

Concat( Value , ',' ) AS ConcatenatedValue

RESIDENT

SomeValues;

vConcatenatedValues = Peek('ConcatenatedValue');

DROP TABLE ConcatenatedValues;

Colin-Albert — Wed, 09 Sep 2015 16:31:20 GMT

Oops - I'm doing it the wrong way round - adding the quotes!

Wed, 09 Sep 2015 17:20:04 GMT

That's it, Petter!

Thanks everyone!