Solved: How could I Upper case? - Qlik Community

ecabanas · ‎2012-10-31

I have this function upper(itemid) as itemid

I have bad results in this Id's: Trans_FBC, did not capitalize!!! any idea why?

Thank's

Eduard

jonathandienst · ‎2012-10-31

Hi

Your statement is correct. I suspect that the itemid value Trans_FBC is coming in via another load statement. Is itemid used in more than one table in the load?

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

jonathandienst · ‎2012-10-31

Hi

Your statement is correct. I suspect that the itemid value Trans_FBC is coming in via another load statement. Is itemid used in more than one table in the load?

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

ecabanas · ‎2012-10-31

yes, I think I just found the problem, now i'm trying to eliminate the accents!!! 🙂