Automation Lowercase Issue

[jackm75]

Hello all,

I have an automation running that does exactly what I need it to do with the exception of matching properly on email which is being used as a lookup key. It's not matching because one list has a mix of upper and lower case within the email. 

In the lookup box, I can use the lowercase function on the second list, but it's not an option for the first list (image below).  I've fed in json: {lowercase: {$.listUsers.item.email}} which gives the appearance that it would work (second image), however it does not return a value for the email. Let me know what other information would be helpful. 

I'm looking to either make the lowercase function work here, or figure out a way to update the email values within List Users to all be lower case. 

Thank you! 

[jackm75 · Accepted solution]

https://help.qlik.com/en-US/blendr/Content/blend-editor/converting-an-object-with-keyvalues-to-a-lis...

Based on this article, I've found a solution to the issue. Looping over the User List to create the new loweremail value worked!