NerReplace Example: Show Columns from InputTable with Accumulate - Teradata Vantage

select * from td_mldb.NerReplace(
    on (select id, txt as orig_txt, txt from ner_input_distilbert_NER)
    on (select model from ner_models_tst where model_id = 'distilbert-NER') DIMENSION
    on (select tokenizer from ner_tokenizers_tst where tokenizer_id = 'distilbert-NER') DIMENSION
    on (select tokenizer as config from ner_model_configurations_tst where tokenizer_id = 'distilbert-NER') DIMENSION
        using
            Accumulate('id','orig_txt','txt')
) a;

 *** Query completed. 8 rows found. 3 columns returned. 
 *** Total elapsed time was 2 seconds.

      id          22
orig_txt The job title is Senior Analyst, job type is Full-time, last name Zhang. IBAN: CN12ICBK0000000000000123456, companyname: Huarui Global. Age: 37, eye color: brown, Ethereum address 0xE853c56864A2ebe4576a807D26Fdc4A0ada51919, phone IMEI 353072070237232.
     txt The job title is Senior Analyst, job type is Full-time, last name PER. IBAN: ORGORG12ORGORGK0000000000000123456, companyname: ORGORGORG. Age: 37, eye color: brown, LOCORGeum address 0xE853c56864A2ebe4576a807D26Fdc4A0ada51919, phone ORGORGORG 353072070237232.
      id          17
orig_txt The date of the transaction is 2024-08-07. Date of birth: 1980-03-14. Phone IMEI: 356938035643809. Employer: Quantum Analytics LLC, job type Full-time, job area: Data Science. His Ethereum address is 0x742d35Cc6634C0532925a3b844Bc454e4438f44e and MAC address is 00:1B:44:11:3A:B7.
     txt The date of the transaction is 2024-08-07. Date of birth: 1980-03-14. Phone IMEI: 356938035643809. Employer: ORG, job type Full-time, job area: ORG. His LOCLOCLOC address is 0x742d35Cc6634C0532925a3b844Bc454e4438f44e and MAC address is 00:1B:44:11:3A:B7.
      id           5
orig_txt Please send the package to Building 7, 300 Lincoln Avenue, Boston, 02111.
     txt Please send the package to Building 7, 300 LOC, LOC, 02111.
      id          13
orig_txt Samantha's city is New Orleans, and she works for TechNova Solutions. Her credit card number is 5555 4444 3333 2222, CVV 456, and the issuer is MasterCard. Her Ethereum address is 0x3f5CE5FBFe3E9af3971dD833D26BA9b5C936f0bE, and she also uses a Litecoin address MQMcJhpWHYVeQArcZR3sBgyPZxxRtnH441.
     txt PER's city is LOC, and she works for ORGORGORG. Her credit card number is 5555 4444 3333 2222, CVV 456, and the issuer is ORGORGORG. Her LOCLOCLOC address is 0x3f5CE5FBFe3E9af3971dD833D26BA9b5C936f0bE, and she also uses a MISCORGMISCn address MQMcJhpWHYVeQArcZR3sBgyPZxxRtnH441.
      id          24
orig_txt Masked number: **** **** **** 1234, middle name Ann, nearby GPS coordinate 40.7128,-74.0060. Credit card number: 4000 1234 5678 9010, CVV 888, BIC: BOFAUS3N, currency: USD, currency code: USD, amount: 300.00, city: New York.
     txt Masked number: **** **** **** 1234, middle name PER, nearby GPS coordinate 40.7128,-74.0060. Credit card number: 4000 1234 5678 9010, CVV 888, BIC: BOFAUS3N, currency: USD, currency code: USD, amount: 300.00, city: LOC.
      id          11
orig_txt Account name: Michael Rogers, account number 192837465, age 34. Please send $12,500.00 to BIC DEUTDEFFXXX. Michael was born on 1989-02-14 and currently lives in building number 17, Main Street, Berlin. His email is michael.rogers@example.com and his IBAN is DE89370400440532013000.
     txt Account name: PER, account number 192837465, age 34. Please send $12,500.00 to ORGORG DEORGORGORGORGORGORG. PER was born on 1989-02-14 and currently lives in building number 17, LOC, LOC. His email is michael.rogers@example.com and his IBAN is DE89370400440532013000.
      id           3
orig_txt Dr. Emily Wang lives at 45B Orchard Street, Springfield, 12345.
     txt Dr. PER lives at 45LOC LOC, LOC, 12345.
      id           9
orig_txt Sophie Dubois's credit card (3714 496353 98431) is linked to her social number 678-90-1234.
     txt PER's credit card (3714 496353 98431) is linked to her social number 678-90-1234.