Combining attributes into a text attribute for an index

fmakawa

Hi Folks,

I have a problem with the table search function and an index I created. I created an index where various decisions where numbered such as decision A =2, decision B = 1 and decision C= 7, as integer. the index would be 2.1.7 as a text. my problem lies with the attribute for the combined values. Its in a text attribute but when I use change attribute to combine those I keep getting an invalid expression or just blank and not even a 0. When I manually add the value the table search function works perfectly and gives me the values I require.

I've tried - change attribute to = "decision A"."decision B"."decision C
"decision A"".""decision B"".""decision C
decision A.decision B.decision C
and I even the full stop into a text attribute called dot with just a full stop in it repeated those -
"decision A"dot"decision B"dot"decision C
"decision A""dot""decision B""dot""decision C
"decision A dot decision B dot decision C

What should I do regarding combining them?

Hopscotch

@fmakawa, to concatenate the strings, use two full-stops

also, only text should be in quotes, not attributes.

The above should look like this:

fmakawa

@Hopscotch its not working. Rather it ends up just disappearing. I have a display text to show what the combined form looks like. before I was getting an invalid expression but now nothing. I dont get the text or warning etc. Additionally, my table search function now gives me the oddest results totally unrelated and which should not be possible either.

Hopscotch

@fmakawa, use the Log Debug behavior to print the values to the debug window and build your expression step by step. That way you can see where it goes wrong.

The above should work if the attributes are the way you described.