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

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?

 

 

 

DanielWillis's avatar
DanielWillis
Valued Contributor
2 years ago

Hi Pizza. It's generally accepted best practice to mark a topic as solved and ask any new questions in a new thread to ensure others can benefit from your experiences.