compare two strings in multirow tool

Question

I need to compare whether same data is available in a column (Part_code_Trimmed) and group them using Multi-row tool. Please check whether the below statement is right

if [Row-1:Part_Code_Trimmed] == [Row+1:Part_Code_Trimmed] then [Part_Code_Trimmed] else [Row-1:Part_Plus1]+1 endif

thank you.

Error thrown: type mismatch in operator '+'

Kenda · Accepted Answer

@pgayath1 If you don't permanently want to change your field to a numeric one, another option would be to use the tonumber() function within your expression.

mceleavey · Accepted Answer

Hi @pgayath1,

The error is because you are comparing two strings in what I take would be a string field, but one of the outcomes returns a numeric calculation.

Try:

if [Row-1:Part_Code_Trimmed] == [Row+1:Part_Code_Trimmed] then [Part_Code_Trimmed] else tonumber([Row-1:Part_Plus1])+1 endif

Ensure the multi-row formula you are creating is of a string type. You can then convert this field using a select tool if required.

Hope this helps.

M.