Can we concatinate String value table with integer value table

[#1]

Hi Qv,

can we concatinate below two tables ,one table have sum of integer values another table value have string.

table1:

Dim1	PRIOR WEEK Data	PRIOR MONTH DATA
101	25	35
102	50	68
103	12	26
104	35	45

table2:

Dim2	PRIOR WEEK Data	PRIOR MONTH DATA
TIMELINE	WK17	WK13-WK17

output look like this.

DIM1	PRIOR WEEK DATA	PRIORMONTH DATA
TIMELINE	WK17	WK13-WK17
101	25	35
102	50	68
103	12	26

Thanks

[#2]

I did not successed in straight i have attached same here.

Thanks

[rwunderlich]

sum() will turn your strings into zeros. So you'll need to conditionally test for the string in the expression like:

=if(NOT IsNum(maxstring(Month)), maxstring(Month), sum(Month))

-Rob

http://masterssummit.com

http://robwunderlich.com

[Anonymous]

Use the only function instead of the sum function in your Straight Table

[rwunderlich · Accepted solution]

See attached using

=if(NOT IsNum(maxstring(Week)), maxstring(Week), sum(Week))

-Rob

http://masterssummit.com

http://robwunderlich.com

[martynlloyd]

Hi, you may encounter problems sorting your text to the top of the table - for this you could use Dual Values:

...

Dual('TIMELINE', 0) as DIM1,

// or

Dual(DIM2,0) as DIM1

...

You will then be able to sort numerically.

Regards,

Marty.

[#7]

Thanku so much rob....can we make it as bold letters for Time Line row alone in that table,I tried to used the Custom format cell option but it should be applicable for whole table but i need only Time Line row.

Time Line WK17   WK13_WK17 
?

thank you

[rwunderlich]

For each Dimension and Expression, press the + sign to access the attributes and use this expression for the "Text Format":

if(IsText(maxstring(Week)),'<B>')

-Rob