Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Concat

ntudev
8 - Asteroid

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

6 REPLIES 6
ArnaldoSandoval
12 - Quasar

Hi @ntudev 

 

The Summary Tool allows you to concatenate.

Concatenate-01.png

hth

Arnaldo

Qiu
21 - Polaris
21 - Polaris

@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
12 - Quasar

@Qiu We are mind readers, with crystal balls ðŸ”®

cjaneczko
13 - Pulsar

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.

 

image.pngimage.pngimage.png

ntudev
8 - Asteroid

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.

 

PICIDAccoutNumberConcat_CodingDifferent?
915182487067912CLEAN,TERMYes
915182487149046AMORTZ,CLEAN,TERMYes
915882489067912CLEAN,TERMNo
915882489149046CLEAN,TERMNo
Qiu
21 - Polaris
21 - Polaris

@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,

0822-ntudev.PNG

Labels
Top Solution Authors