Forum Discussion

OS_Pizza's avatar
OS_Pizza
Contributor III
3 years ago
Solved

Remove suffix from source data where data is coming from a table.

Source A10000_0 Target A10000 How can we achieve it in different ways? 1. Connector SQL query -> Using this in the sql query Select left(Account, len(Account)-2) leaves blank rows in the import ...
Data Sources
  • DanielWillis's avatar
    DanielWillis
    3 years ago

    It shouldn't. Is it something like you're not naming your column when using the function? E.g., should perhaps be: Select left(Account, len(Account)-2) AS Account

ChrisLoran's avatar
ChrisLoran
Icon for OneStream Employee rankOneStream Employee
3 years ago

Or use SQL REPLACE function  ,   REPLACE(MyColumn,'_0','')

  • OS_Pizza's avatar
    OS_Pizza
    Contributor III
    3 years ago

    Using functions in Select statement makes the data disappear in the import step 😞