Automation Lowercase Issue

jackm75 — Wed, 07 Sep 2022 00:01:11 GMT

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!

Re: Automation Lowercase Issue

jackm75 — Wed, 07 Sep 2022 13:47:49 GMT

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

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

topic Automation Lowercase Issue in Qlik Automate

Automation Lowercase Issue

Re: Automation Lowercase Issue