0

Extracting individual records from a sub-table to text field

Screen Shot 2020-02-10 at 3.30.49 PM

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

null
    • wynand
    • 4 yrs ago
    • Reported - view

    If use the following code I get the array

    'other similar2'.'1 - EV master file'.UID_Key

    if 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_Key

    Then I get no array

    • wynand
    • 4 yrs ago
    • Reported - view

    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 >""

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 938Views