We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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