Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hi Robert
Thank you for your reply
kind regards
Nayan
You are welcome.
Thanks for feedback