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

OS_Pizza's avatar
OS_Pizza
Contributor III
3 years ago

Absolutely ! I have missed that , Thanks DanielWillis ChrisLoran . This will save a lot of time by discarding complex expression used at Source Dimension. Better to clean data at source then at mapping.

One more question. Do you happen to know about -

1. Text Fill settings or Substitution settings. What is the purpose of these two?