Skip to main content
  • EN

Hi,

I would like to modify a comment section in my table. The comment section is intended when there's a change between two roads. For example, when Road 6 is changing for Road 6-A, the comment section writes : Road 6 is becoming Road 6-A. Now, I got a lot of these examples but the comment section is almost blank (with some examples as above). I want to describe those Roads change when the comment section is blank. I got 4 000+ roads changes, so a formula would be appreciated.

 

Thanks.

Depends on what your data looks like but are you hoping to do some change detection between datasets? If so, you could use the ChangeDetector to compare the datasets (output both original and requestor) then join and concatenate a "Comments" string with the change details.

Reply


Community Stats

30,177
Posts
114,556
Replies
37,843
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.