topic Concatenate 2 fields in QlikView

Concatenate 2 fields

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

Hi community,

I have table A like this

TableA:
Load

FieldA,
FieldB,

From...

Concatenate(TableA)
Load

FieldC,

FieldD,

From...

I wanna create a key with fieldA and fieldC, how can i do?

Thank you for the help.

Best Regards,

Bruno Paulo

Re: Concatenate 2 fields

YoussefBelloum — Tue, 14 Nov 2017 10:11:51 GMT

Hi,

basically to create a key you can do this: fieldA&'_'&fieldC as KEY

but you should have the fieldA and the fieldC on both tables..

Re: Concatenate 2 fields

brunopaulo — Tue, 14 Nov 2017 10:13:20 GMT

exactly my problem, field A is on table A and field C is on table B. Im concatenating the tables for single table but i need dat key.

Re: Concatenate 2 fields

devarasu07 — Tue, 14 Nov 2017 10:14:46 GMT

Hi,

You can try like this,

TableA:

LOAD * INLINE [

FieldA, FieldB

A, 1

B, 2

C, 3

D, 4

E, 5

];

Concatenate(TableA)

LOAD * INLINE [

FieldC, FieldD

G, 8

H, 27

I, 30

K, 17

Z, 11

];

Final:

load *, FieldA &'|'& FieldC as %Key Resident TableA;

Drop table TableA;

Thanks,Deva

Re: Concatenate 2 fields

PabloOrtiz — Tue, 14 Nov 2017 10:17:44 GMT

Hello Bruno, try something like this

TableA:

Load

FieldA,

FieldB,

From...

Concatenate(TableA)

Load

FieldC,

FieldD,

From...

rename TableA to _TableA;

TableA:

load *, FieldA & '.' & FieldB as KEY resident _TableA;

drop table _TableA;

Re: Concatenate 2 fields

brunopaulo — Tue, 14 Nov 2017 10:19:21 GMT

Thank you, perfect. I was searching for this