Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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