topic Concatenate two fields but not in script in QlikView

Concatenate two fields but not in script

ivandrago — Fri, 23 Jul 2010 11:52:46 GMT

Hello,

Is there a fuction that I can use to concatenate two fields together that are coming from two different tables without having to do this within sthe cript? For example i want the filed(Concat Field) to be like below:

TableA	TableB	Concat Field
Cat	New	Cat_New
Dog	Old	Dog_Old
Hamster	Old	Hamster_Old

Concatenate two fields but not in script

Fri, 23 Jul 2010 12:13:35 GMT

Hi,

Did you Tried this TableA &'_'& TableB ?

Concatenate two fields but not in script

john_duffy — Fri, 23 Jul 2010 20:40:59 GMT

Hi Ivan.

Is there a link between the two tables?

Concatenate two fields but not in script

stevedark — Sat, 24 Jul 2010 00:19:28 GMT

Hi Ivan,

Where are you wanting to see the concatenated field? Srinivasan has already posted the syntax for creating the combined value. If you require it as a dimension in a chart you will need to 'Add Calculated Dimension'. There is no way of having the concatenated field in a list box or a table box in QV 9.0, but I believe you will be able to in QV 10.

If you want the field usage to be more robust dealing with it in the load script would be the best place to do the concatenation. Use of the JOIN statement with a RESIDENT load would probably be required.

Regards,
Steve