How to create a column to suggest change of a row in a table

asked 2019-09-09 09:38:56 -0600

miroliu gravatar image

Hi, I am working on a project and need to change some records value conditionally using field replacer. Is it possible to use expression evaluator to create a column to suggest if there is a transformation of a row where 0 = no transform, 1 = transform?

Thanks

edit retag flag offensive close merge delete

Comments

Are you looking for a built-in way that will tell you if a record has changed or just a way to create a new column and set its value conditionally in Expression Evaluator?

iamontheinet gravatar imageiamontheinet ( 2019-09-09 14:19:23 -0600 )edit

I am looking for a way that can create a new column 'flag_transform' and set its value (1/0) based on whether the value of any other fields is changed.

miroliu gravatar imagemiroliu ( 2019-09-09 14:26:19 -0600 )edit

Creating a new column and setting its value conditionally is def easy to do. But the trick is in comparing before and after values because the original values aren't stored/retained. Can you update your question and add more details about your pipeline, processors being used, and use case?

iamontheinet gravatar imageiamontheinet ( 2019-09-09 16:53:21 -0600 )edit