After Concatenate a matching field goes to null

[#1]

Hi, I've used the  Concatenate statement in my script to merge two tables, but I'm not getting the result that I'm looking for. A matching field between the two tables goes to null.

Table A

FieldA	FieldB
1	10
2	20

Table B

FieldB	FieldC
2	50
3	60

After Concatenate my result is (the values of FieldB on TableB go to null) :

FieldA	FieldB	FieldC
1	10
2	20
		50
		60

[sunny_talwar]

Cannot seem to replicate your issue.

Can you may be share your sample?

[#3]

That's right, in regular basis that's the behaviour of CONCATENATE, but I'm tryng to figure it out in wich scenarios this can happen?

[swuehl]

I think it has to do with how you load your tables and do the CONCATENATE.

As Sunny showed, we can't replicate the issue with the data provided, so we need to find out where your setting is differs from above.

Would you mind sharing a small sample QVW that demonstrates your issue or at least some more details, like the your script / document log, more detailed description of the values contained in that common field etc?

[#5 · Accepted solution]

It was something about a missing field in the relation between the main fact table and its foreign key, in the 2nd table with less field I just add a 0 named fiel into the script and works.

Thanks

[effinty2112]

Hi Pedro,

It looks as if your script is something like

concatenate([Table A])

Load

FieldC //FieldB omitted

Resident [TableB];

[swuehl]

Ok, I am glad CONCATENATE works as expected, though I haven't understood yet how your key fields messed this up.

Never mind, please close this thread.