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

OS_Pizza's avatar
OS_Pizza
Contributor III

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