Using a variable to select a field

Anonymous User — Mon, 16 May 2022 01:33:58 GMT

Hi everyone,

How are field names stored as variables? I thought it was just text but I think I'm missing something.

I'm trying to calculate a field ('Flow') in a table, where the data already exists in one of F1, F2, F3,... FN fields in the table. There's another field (destination) that I want to use to point to the right F field. So:

Flow = $feature[Concatenate('F', Text($feature[destination]))]

So $feature[destination] should point to the right 'F' field to use. But it says there's no 'F3' field for example, but if I go

Flow = $feature['F3']

then it works. I also found that even

Flow = $feature[Concatenate('F', Text(3))]

doesn't work (no such field as 'F3'). What am I misunderstanding about field names? Why is 'F3' a valid field but Concatenate('F', '3') isn't?

Thank you!

topic Using a variable to select a field in ArcGIS Pro Questions

Using a variable to select a field