Concat

[ntudev]

does anyone know how to concatenate and then compare the value in the concat to another concat value? is there a formula for that?

[ArnaldoSandoval]

Hi @ntudev 

The Summary Tool allows you to concatenate.

hth

Arnaldo

[Qiu]

@ntudev 
As mentioned by @ArnaldoSandoval , The summarize tool can do that.

But you mentioned about comparing, so it will be much better if you can provide some sample Input and desired output, so we can take a close look.

[ArnaldoSandoval]

@Qiu We are mind readers, with crystal balls 🔮

[cjaneczko]

Are you looking to Concatenate multiple fields? As long as they are strings, you can use the "+" in formula to concatenate multiple fields together. See the flow below. In the dataset, Cust ID, Cust Name, State and String are in the source table. The Concat field is calculated by concatenating Cust ID-Cust Name-State. Then the Test field is used to compare the String field and Concat field to see if they are the same. True = Same, False = Different.

[ntudev]

Sorry everyone @Qiu @ArnaldoSandoval @cjaneczko  here is more details. Basically i need to group by PICID and then see if the Concat_Coding is different. if its different i need it to say its different in a new column.

PICID	AccoutNumber	Concat_Coding	Different?
91518248	7067912	CLEAN,TERM	Yes
91518248	7149046	AMORTZ,CLEAN,TERM	Yes
91588248	9067912	CLEAN,TERM	No
91588248	9149046	CLEAN,TERM	No

[Qiu]

@ntudev 
Thank you for the details.

I assume you want to compare the value of " Concat_Coding" of current row to that of upper of lower row,