topic Re: concatinate the fields in QlikView

concatinate the fields

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have 1400 fields in my data but i want to concatenate all fields how to concatenate all the fields by using looping

vishsaggi — Mon, 27 Aug 2018 18:29:51 GMT

May be this helps check here:

however, i still wonder why you want to concatenate 1400 fields. They are many to be in the data model.

manoj217 — Tue, 28 Aug 2018 04:08:51 GMT

i have 1400 fileds but i want to left first 5 fields and concatenate remaining 1396 fields

marcus_sommer — Tue, 28 Aug 2018 06:37:58 GMT

Do you mean fields or fieldvalues within a field? What is the aim of concatenating them?

- Marcus

manoj217 — Tue, 28 Aug 2018 09:35:45 GMT

i have fields like A,B,c,d,e,f.......upto 1000 fields. now i want to concatenate fields c,d,e,f,g.....upto 1000. just i am omit A,B like that i want.

there we have more than 1000 fields so i can't write concatenate keyword to all the fields so i want automatic looping operation

andrey_krylov — Tue, 28 Aug 2018 10:16:35 GMT

I think you need a code like below

vString = '';

FOR vCounter = 1 TO NoOfFields('YourTable')

vCurrentField = FieldName($(vCounter), 'YourTable');

IF not Match(vCurrentField, 'A', 'B', 'C'...) THEN

vString = vString & ', [$(vCurrentField)]';

ENDIF

vString = Right(vString, Len(vString) - 2);

Concatenate([YouNewTable]): LOAD $(vString) Resident [YourTable] ;

manoj217 — Tue, 28 Aug 2018 13:10:04 GMT

it is showing error

andrey_krylov — Tue, 28 Aug 2018 13:20:00 GMT

Sorry, did not check. In Match() function paste fieldnames you don't want