Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to concat two fields in the same table n how?
hi,
yes you can concat two field in dimension or expression using & operator
Example: field1 & field2
here is the attached example:
the first concat field is a1 but i want output as
row 1: a
row 2 : 1
not a1 then what to do?
Use:
row1 & ':' & row2
Regards
Arun Goel
I dont understand what you try to do...
Would you please explain more?
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????
Found the attached file:
See the calculated dimension and expression of table
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.
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
use below code
'Row1:'&field1&'
'&'Row2:'&field2
hope this helps