Forum Discussion

wahlborn's avatar
wahlborn
New Contributor II
6 years ago
Solved

Assistance requested creating pipeline for SQL query-->mapper-->text file

My goal is to execute a SQL query, return data, and format it so that it is accepted by a custom app we run here. So far, I have extracted the necessary data and formatted it using a mapper. The ma...
  • nsingam's avatar
    4 years ago

    Hi,

    Use the below expression in a mapper. After that use the Splitter snap to get the details.
    

    $Systems.map(x => {“Systems” : x.substring(x.indexOf(“(”)+1, x.indexOf(“)”))})