Padding, RPAD or LPAD in Looker Explore

[suneethi_kurupp]

There is a need for us to generate fixed length fields from a Looker dashboard. Is there anyway I can RPAD or LPAD from the explorer and not from the LookML?

Thanks!!

[sharifahSY · Accepted solution]

Hi @suneethi_kurupp 

Unfortunately the padding functions are not part of the String functions available for use in the custom dimension (refer to the documentation to create the dimension and available string functions)

For better governance and consistency, consider performing this step in the LookML layer. Alternatively, it can be done during data preparation if more flexibility is needed.

Hope this helps!