AnsweredAssumed Answered

Data Reader ETL issue with Text file

Question asked by dchand on May 8, 2018
Latest reply on May 8, 2018 by dchand

Hello All,


I have a data reader that reads an ascii tab delimited file. It updates several cubes correctly. However, I have an issue with one of the transformations. I am reading text values and converting this to an integer based on the text value in the source file.



I have used various versions of the formula above including E & F columns to make the formula simpler. These formulas perform the correct transformation when I preview the values in the data reader e.g.

However, when I execute the data reader, the cube ends up with the default value (9 in this case). Has anyone else experienced this issue?