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

Here's an example of using REPLACE in a SELECT statment where data does not disappear:

I am pretty sure this result set would appear in the import step just as it appears in the query result list.
Could you be more specific on what is meant by "the data disappears" ?