Question

I would like to modify a comment section in my table

  • 18 May 2021
  • 1 reply
  • 1 view
M

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.

1 reply

chrisatsafe
Rank
Badge +2

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

28,661
Posts
109,318
Replies
36,528
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.