Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concat

Is it possible to concat two fields in the same table n how?

9 Replies
Not applicable
Author

hi,

yes you can concat two field in dimension or expression using & operator

Example:   field1 & field2

here is the attached example:

Not applicable
Author

the first concat field is a1 but i want output as

row 1:  a

row 2 : 1

not a1 then what to do?

Not applicable
Author

Use:

row1 & ':' & row2

Regards

Arun Goel

Not applicable
Author

I dont understand  what you try to do...

Would you please explain more?

Not applicable
Author

m nt able to tel u what i want xactly....

i have 2 different date fields n i want to join master calenders date field to both but i can join it to any 1 field at a time for tat reason i want to join these two date fields and make it as a single field so that i can join it to my master calender date field...... is there ny other way to solve such problem????

Not applicable
Author

Found the attached file:

See the calculated dimension and expression of table

Not applicable
Author

Hi,

Just concatenate both the Tables

EG:

Table1:

ID   Date             Date1

1    11/12/2011    13/12/2011

2    12/12/2011     14/12/2011

so,

in qlikview,

Table1:

Load ID,Date from Table1.xls;

concatenate(Table2)

Load ID,Date1 as Date from Table2.xls;

final output:

ID Date

1   11/12/2011

2    12/12/2011

1    13/12/2011

2    14/12/2011

Then join this with master calendar Date field.

Not applicable
Author

Hi ,

what you want to say is concatenating fields means creating a composite

key then waht arun Goel is saying is correct.

Warm Regards

Anant Dubey

SunilChauhan
Champion
Champion

use below code

'Row1:'&field1&'

'&'Row2:'&field2

hope this helps

Sunil Chauhan