POST
|
Hello, After having searched a lot, I am writing to you because I am desperate not to find!I try to fill a field thanks to a join with an associated table. In this field, I need to retrieve a value from this table. The relationship is 1-M but I have to take the first row. I have a script but nothing happens: var parent_id = $feature.OBJECTID var tbl = FeatureSetByName($datastore, "TYPES_COMMERCE"); // Filter the parent class for only related features var parent_records = Filter(tbl, "OBJECTID = @parent_id"); var i = 0; var new_value = 'Operational'; // Loop through each feature, create a dict of the Global ID and the new value date for (var row in parent_records) { new_value= row['TYPE_COMMERCE'] //Test on one value to see if it's work } return new_value Any help will be very appreciated!
... View more
11-24-2020
09:04 AM
|
0
|
0
|
92
|
POST
|
Hi @XanderBakker, yeah it works perfectly. Thank you so much. I very appreciate your help and your reactivity. Thank a lot
... View more
11-12-2020
03:04 AM
|
0
|
0
|
263
|
POST
|
Hi Xander, do you know if it possible to add an element in the split? Sometimes , my strings are like this : AVENUE D'ARES so I need to keep ARES and not D'ARES. I would like find at the end :ARES (AVENUE D'). Do you know if it's possible to have this? Maybe with a replace for the ' by a " " but i'm not sure. If you have a idea about this problem, I will be grateful.
... View more
11-10-2020
08:50 AM
|
0
|
2
|
274
|
POST
|
HI Xander, thanks for your answer. My problem is that I want the last word of the address, return it on the First Place and concatenate the other part of the address to return it after the First place. I don't know if it's clear , i put an example : RUE GEORGES BONNAC would be BONNAC (RUE GEORGES). Thanks Xander
... View more
11-06-2020
07:19 AM
|
0
|
1
|
274
|
POST
|
Hello, I'm a newbie on Arcade, i very like this language but it's new for me and I have some difficulties to find my happiness! I would like to rearrange a string Address in a field, I would like put the last word in 1st place and the other after (in parenthesis) For example: RUE GEORGES BONNAC will be BONNAC (RUE GEORGES). I Think, I have to split my string et count the words but i got a dictionary error and I don't what to do. Thank you everybody.
... View more
11-06-2020
01:09 AM
|
0
|
8
|
386
|
Online Status |
Offline
|
Date Last Visited |
3 weeks ago
|