topic Re: to concat variable in QlikView

to concat variable

Tue, 23 Oct 2012 14:37:18 GMT

Hi,

The &' '& is not working.

somebody help...... ?

Thanks,

for vVariableNo = 0 to NoOfRows('POLIST')

Let vPO = $(vPO) &' '& FieldValue('PO',vVariableNo);

next vVariableNo

Re: to concat variable

MayilVahanan — Tue, 23 Oct 2012 14:46:09 GMT

try like this

Let vPO = 'test';

for vVariableNo = 0 to NoOfRows('POLIST')

vPO = vPO &' '& FieldValue('PO',$(vVariableNo));

next vVariableNo

Hope it helps

Re: to concat variable

Tue, 23 Oct 2012 14:53:19 GMT

Hi Mayil,

but i don't want test in my string.

I'm trying to put all the po number into variable by coma deliminator.

and i will use this to loop in my load script.

so i don't have to hardcode my PO number.

so. the result should be...

1234, 2345, 3454

Re: to concat variable

MayilVahanan — Tue, 23 Oct 2012 15:00:39 GMT

Let vPO = '';

for vVariableNo = 0 to NoOfRows('POLIST')

vPO = vPO &','& FieldValue('PO',$(vVariableNo));

next vVariableNo

vPO = right(vPO,len(vPO)-2);

Hope it helps

Re: to concat variable

CELAMBARASAN — Tue, 23 Oct 2012 15:02:26 GMT

Try with this

POLISTConcat:

Load Concat(Distinct PO,',') AS POConcat

Resident

POLIST;

LET vPO = FieldValue('POConcat',1);

DROP Table POLISTConcat;

Re: to concat variable

Tue, 23 Oct 2012 15:05:03 GMT

Mayil,

Sorry, i didnt see you remove the dollor sign. so it works.

i do it like this though.

Let vPO = Text(FieldValue('PO', vVariableNo)) &','& (vPO)

vPO cant be in front, it create some empty value. so i do it at the back.

Thanks

LET vPO = FieldValue('POConcat',1); will only give one value isnt it?

as i understood. the 1 represent the row?

Re: to concat variable

CELAMBARASAN — Tue, 23 Oct 2012 15:07:23 GMT

POLISTConcat:

Load Concat(Distinct PO,',') AS POConcat

Resident

POLIST;

is a new table by concatenating the all the PO field values with comma separator.

Did you checked it out how it works?

Re: to concat variable

MayilVahanan — Tue, 23 Oct 2012 15:09:07 GMT

Fieldvalue(fieldname , n)

Returns the field value found in position n of the field fieldname (by load order). Fieldname must be given as a string value, e.g. the field name must be enclosed by single quotes. The first field value is returned for n=1. If n is larger than the number of field values, NULL is returned.

Yes,

FieldValue('POConcat',1); gives first value...

Use Celambarasan suggestion also, its easy know...

Re: to concat variable

Wed, 24 Oct 2012 08:28:19 GMT

Yes, i have problem with the loop, because at the end of the loop, i always get and empty value...

So i'm using the concat function.. i didn't know it works this way...

But thanks gentlemen for your help.