topic Re: How to concatenate fields and store into new variable? in QlikView

How to concatenate fields and store into new variable?

Thu, 26 Nov 2015 08:19:38 GMT

I have 6 columns in a table called RPUNit namely;

pcinum

mdinum

binum

sinum

parcel

ptype

I need to fetch data for each fields and concatenate them and store into new variable called pin2.

I need to see something like this: pcinum-mdinum-binum-sinum-parcel-ptype (concatenate values then stored in pin2)

Re: How to concatenate fields and store into new variable?

morganaaron — Thu, 26 Nov 2015 09:55:31 GMT

Hi Mark,

You want to concatenate every row of the table together? Or are you talking about trying to return a variable for every row? Are the fields all dimension fields in your table?

Re: How to concatenate fields and store into new variable?

Anonymous — Thu, 26 Nov 2015 10:01:48 GMT

do this in the same table at script level::

pcinum&'-'&mdinum&'-'&binum&'-'&sinum&'-'&parcel&'-'&ptype as [pcinum-mdinum-binum-sinum-parcel-ptype]

Re: How to concatenate fields and store into new variable?

Anonymous — Thu, 26 Nov 2015 10:03:44 GMT

You can store into variable but it will be 1 value at a time

pcinum&'-'&mdinum&'-'&binum&'-'&sinum&'-'&parcel&'-'&ptype as Pin2 //Pin2 is new field name

Re: How to concatenate fields and store into new variable?

effinty2112 — Thu, 26 Nov 2015 19:54:30 GMT

Hi Mark,

We need to be careful how we use the word concatenate in QlikView land. I guess what you mean is string concatenation e.g. "dog" & "cat" & "mouse" = "dogcatmouse".

In QlikView dashboard design the word can have that meaning but in scripting it's used mostly to refer to the Concatenate operation that combines two tables. If you're coming from a SQL background you'll maybe want to call this a Union.

If you are referring to string concatenation are you, to repeat Aaron's question, wanting to create a variable for each row?

Cheers

Re: How to concatenate fields and store into new variable?

MarcoWedel — Thu, 26 Nov 2015 21:48:45 GMT

Hi,

if you just "need to see something like this", then you could calculate the concatenated value in a straight table like this:

hope this helps

regards

Marco