Pentaho

 View Only

 Hello everyone, I have a question about the Pentaho Metadata Editor.I want to join two tables and want to add an lower Case to both columns. Is there a function to do so? Or another way to do that?

  • Pentaho
  • Pentaho
Pascal Vallon's profile image
Pascal Vallon posted 07-09-2021 11:37

 Im working with the Version 9.0.0.0-423


#Pentaho
Ibrahim Bolarinwa's profile image
Ibrahim Bolarinwa

For this kind of problem, I'd suggest using an SQL formula in the business view column to create a lower case column (tick the 'formula is exact' box to make sure​ the formula is passed to the DB) or you can move the string manipulation to the reporting engine and use the native formulas in PRD or JavaScript in CDE. The formulas in Metadata editor are mostly for facilitating joins not data manipulation. I'm sure there's some other clever stuff that can be done with format masks to get similar results.