Section access space issue

[#1]

Hi All,

I need to use section access for hierarchy level that have spaces. Is this possible?

section access;

load * inline

[ACCESS,PWD,Level

ADMIN,ADMIN,AS BCD

USER,USER,AS CVD

section application ;

I tried single quotes and double quotes but it doesn't seem to work.

Thanks for your help.

[Gabriel]

Hi,

What do you mean space?

Is this space coming as a result of NULL (missing value from database) or NULL (result of joins in QlikView) or space as in -?

Please try and clarify this or mest bet post a sample file

Best Regards

[#3]

Spaces between data values

As you can see above AS BCD and AS CVD

[#4]

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, USER1
USER, USER2, USER2
USER, USER3, USER3
];
Section Application;

LOAD * INLINE
[

USERID, Level
USER1,AS BCD
USER2,AS CVD
USER3,AS VDB
]

[Clever_Anjos]

Level should be LEVEL (Fields into Section Access must be UPPERCASE)

[Peter_Cammaert]

INLINE tables don't threat quotes or double quotes any differently from other characters. There are only few special characters: comma, square brackets and CR/LF. All the others are taken as-is and included in the stored values. So if your values contain spaces (not leading or trailing, they will be omitted), include them in the INLINE specification exactly as they occur in your other fields. Specify AS BCD and AS CVD and they will be stored as strings 'AS BCD' and 'AS CVD'.

Remember that both field names and field values in an SA table are implicitly converted to UPPER CASE. For linking to work as expected, make sure that the corresponding fields in Section Application also have upper case names and contain upper case values.

Peter

[Gabriel]

Hi,

Since this is INLINE table just add single quote ' to the value in the table

[#8]

Space didn't bother  you in Inline table or section table  Are you facing any issue ?