Concat
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
does anyone know how to concatenate and then compare the value in the concat to another concat value? is there a formula for that?
- Labels:
- Data Investigation
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Qiu We are mind readers, with crystal balls 🔮
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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,
![](/skins/images/A29875142F332EEF75F19ED75711F41B/responsive_peak/images/icon_anonymous_message.png)