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 step.
2. Data Source ?
2.a. Logical expression
Return args.Value.Replace("_0", String.Empty) - This works fine.
2.b. What about Text Fill settings or Substitution settings?
3. Transformation Rule ?
Solved! Go to Solution.
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" ?
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?