Discussion Board for collaboration related to QlikView Deployment.
I have table A and B, and I want to create table A&B. Either the solution is not as straightforward as I would think or I have a blackout.
I'm kind of stuck here. My own solution is quite complicated and involves creating 2 fields and concatenating them
LOAD * INLINE [
ID, Limit Temp
Limit & [Limit Temp] AS Newfield
Drop Table A;
Is there a better (more elegant) way to solve this?
Appriciate any help
If it's exactly like that, use ApplyMap():
* INLINE [
ApplyMap('TableB', ID, Value) AS Value, // if ID does not exist in TableB it will store the value existing in TableA
'SQL' AS Source
FROM ... // source for table A
The column "Source" was just there to show that a simple concatenate won't fix it. But the field can have other values than "SQL" only.
Fine. It's more important here if the use of ApplyMap() is enough, and this depends on whether Table B has 2 and only 2 fields. If it has more, it should be a JOIN or several nested ApplyMap()s.
And no, the CONCATENATE will not work because you don't want to add more lines, bot to modify those which already exist.