Extracting individual records from a sub-table to text field
I have a subtable with 32 records, only 6 of those qualify from further filter criteria. I want to create an individual text file showing the array of the ID codes of those six records. I am stumped, I get the 32 record UID array but not the 6 in the table
2 replies
-
If use the following code I get the array
'other similar2'.'1 - EV master file'.UID_Keyif I use an if statement like this
if 'other similar2'.'1 - EV master file2'.Fuel_Type = Fuel_Type then'other similar2'.'1 - EV master file'.UID_KeyThen I get no array
-
The criteria in the table are
- '1 - EV master file'.'Model Year' = number('1 - EV master file2'.'Model Year') or '1 - EV master file'.'Model Year' = number('1 - EV master file2'.'Model Year') - 1
- '1 - EV master file'.Fuel_Type = '1 - EV master file2’.Fuel_Type
- '1 - EV master file’.WEV_show = empty
- UID_Key >""
Content aside
- 5 yrs agoLast active
- 2Replies
- 938Views