Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Merging 2 fields from 2 separate tables

Hi

I have field called say, "Item Serial Number" in Table A and I have another field called , say " Component Serial Number" in Table B.

I want to create combine the two fields and rename it as "Serial Number".

How do I do this.

kind regards

Nayan

Tags (1)
1 Solution

Accepted Solutions

Re: Merging 2 fields from 2 separate tables

TableA:

load * inline

[ Item Serial Number

100

200

]

;

join

TableB:

load * inline

[Component Serial Number

AA

BB

];

temp:

load [Item Serial Number] &[Component Serial Number] as IS resident TableA;

drop table TableA

4 Replies

Re: Merging 2 fields from 2 separate tables

TableA:

load * inline

[ Item Serial Number

100

200

]

;

join

TableB:

load * inline

[Component Serial Number

AA

BB

];

temp:

load [Item Serial Number] &[Component Serial Number] as IS resident TableA;

drop table TableA

Re: Merging 2 fields from 2 separate tables

Not sure, but is this what you want?

where first two serial numbers are from Table A and the last two are from Table B

[Table A]:

load * inline

[Item Serial Number

123abc

4561bc

]

;

[Table B]:

load * inline

[Component Serial Number

kl123

jk453

];

[Combined Serial Number]:

NoConcatenate

LOAD [Item Serial Number] as [Serial Number]

Resident [Table A];

Concatenate ([Combined Serial Number])

LOAD [Component Serial Number] as [Serial Number]

Resident [Table B];

DROP Tables [Table A], [Table B];

Best,

S

Not applicable

Re: Merging 2 fields from 2 separate tables

Hi Robert

Thank you for your reply

kind regards

Nayan

Re: Merging 2 fields from 2 separate tables

You are welcome.

Thanks for feedback