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.

 

=IF(TRIM(UPPER(C10))="FILLED",1,IF(TRIM(UPPER(C10))="VACANT",2,IF(TRIM(UPPER(C10))="CLOSED",3,9)))

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?

 

Thanks,
Dinesh

Outcomes