Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data String / Whats Been Added or Removed

DelData
9 - Comet

Hi There,

 

I have a sample excel of a check i have to make on what has changed to strings. The attached workflow shows i get data with id's with now and before values : see data check input.png

 

What i want to do per row is look at what has changed from before to now and confirm what change was..

 

e.g Row id 1

      Now = Fellowes Folders, Blue

      Before = Blue

 

...therefore the change for row 1 is that Fellowes Folders has been Added....the output that i want is shown in data check output.png

 

..any help would be great :)

2 REPLIES 2
ChrisTX
16 - Nebula
16 - Nebula

Attached is one option.  It compares word counts, before versus now.

 

Chris

DelData
9 - Comet

Wow!!...this is a nice solution and something i know i would not have been able to do.

Thank you for taking time out to provide such a great answer...👍

Labels
Top Solution Authors