topic Re: Section access works with XLS but wont work with SQL in Connectivity & Data Prep

Section access works with XLS but wont work with SQL

shalbeguidewire — Tue, 13 Aug 2019 17:35:11 GMT

Hi,

I am trying to add SQL query instead of XLs to my section access.
When I add the query it wont apply the section access.

My table is exact replica of my excel.

Thanks,

Sameer

Re: Section access works with XLS but wont work with SQL

Vegar — Tue, 13 Aug 2019 20:07:49 GMT

You write that the table is the same as your excel sheet, but have you made sure that the output of you section access SQL query is the same as your excel. If not, try to load the Section Access table as normal tables to verify that the output is as expected.

Is it possible for you to share the Section Access script?

Is your field names and field values used in the section access in UPPER CASE? If not please make sure they are.

Do you expect the Section Access values to be numeric values starting with inital zeroes like 0000123 or 099999? Some times Qlik are automaticly converting numbers with leading zeros into digits without 000123 becomes 123 and 099999 becomes 99999.

Re: Section access works with XLS but wont work with SQL

shalbeguidewire — Wed, 14 Aug 2019 17:24:54 GMT

Hi,

The output matches the XLs. Should I do the upper in SQL query or Qlik Load ?

Regards,

Sameer

Re: Section access works with XLS but wont work with SQL

Vegar — Wed, 14 Aug 2019 17:37:07 GMT

It doesn't matter where you do it as long as the final Section access table and fields are in upper case.