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
8 - Asteroid

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

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

 

Chris

DelData
8 - Asteroid

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...👍

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels