Forum Discussion

OS_Pizza's avatar
OS_Pizza
Contributor III
2 years ago

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
    2 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
Valued Contributor
2 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" ?

  • OS_Pizza's avatar
    OS_Pizza
    Contributor III
    2 years ago

    It works fine in the SQL query but when you use it in the connector rule , the data doesnt show up in the RegisterID column.

     

    • DanielWillis's avatar
      DanielWillis
      Valued Contributor
      2 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