Apache Pinot

Hi All, what's a neat way of extracting strings from a concatenated sting. Example 'Raj|25|Male' should go to three fields Name, Age, Gender.

You probably need 3 columns with 3 transform functions reading the same source.

Thanks <@UDQU92KBK>, below is my sql function, but looks like there is no equivalent transform ingestion config

`substr(PE_deal_key, strpos(PE_deal_key, '-', 1) + 1, strpos(PE_deal_key, '-', 2))`

```{  
  "ingestionConfig": {  
    "transformConfigs": [  
      {  
        "columnName": "name",  
        "transformFunction": "splitPart(sourceColumn, '|', 0)"  
      },  
      {  
        "columnName": "age",   
        "transformFunction": "splitPart(sourceColumn, '|', 1)"  
      },  
      {  
        "columnName": "gender",  
        "transformFunction": "splitPart(sourceColumn, '|', 2)"  
      }  
    ]  
  }  
}```