topic Merging 2 fields from 2 separate tables in QlikView

Merging 2 fields from 2 separate tables

Wed, 04 Mar 2015 10:11:04 GMT

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

Re: Merging 2 fields from 2 separate tables

robert_mika — Wed, 04 Mar 2015 10:34:55 GMT

TableA:

load * inline

[ Item Serial Number

100

200

]

;

join

TableB:

load * inline

[Component Serial Number

];

temp:

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

drop table TableA

Re: Merging 2 fields from 2 separate tables

sunny_talwar — Wed, 04 Mar 2015 11:10:36 GMT

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,

Re: Merging 2 fields from 2 separate tables

Wed, 04 Mar 2015 11:13:07 GMT

Hi Robert

Thank you for your reply

kind regards

Nayan

Re: Merging 2 fields from 2 separate tables

robert_mika — Wed, 04 Mar 2015 11:28:32 GMT

You are welcome.

Thanks for feedback