topic Search Fields on Load in QlikView

Search Fields on Load

Anonymous — Wed, 14 Dec 2011 16:07:55 GMT

I have a simple select * query that loads a table consisting of about 20 fields. 10 of these fields are long text fields. Upon loading the data, I need to search all 10 of these fields to see if the string "requested" exists in any of these fields. How many matches it finds doesn't matter, just a true or false is needed if at least one match is found. So I'm thinking I'd be able to do this with a proceeding load where I create a new field called "request status" that holds either "true" or "false". What is the best way to do this without a bunch of nested If statements using substringcount?

Search Fields on Load

jagan — Thu, 15 Dec 2011 06:03:01 GMT

Hi,

I think there is no straight function for this. You can try this

If(Field1 = "requested OR Field2 = "requested".............................OR Field10 = "requested", 1, 0) AS [request status]

Hope this helps you.

Regards,

Jagan.