Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please give answer to use PEEK or any function within Qualify and Unqualify statement. below is eg script
QUALIFY *;
funcPEEKtbl:
LOAD Year,
Sales,
PEEK(Sales) As PeekfuncWrk
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
UNQUALIFY *;
result is NULL as done with below experiments
1. PEEK(Sales) As PeekfuncWrk
2. PEEK('Sales') As PeekfuncWrk
3. PEEK(funcPEEKtbl.Sales) As PeekfuncWrk
4. PEEK('funcPEEKtbl.Sales') As PeekfuncWrk
5. PEEK(funcPEEKtbl.Sales,-1,funcPEEKtbl) As PeekfuncWrk
6. PEEK('funcPEEKtbl.Sales',-1,'funcPEEKtbl') As PeekfuncWrk
but PEEK function works correctly without Qualify statment
Generally asking below question
1. whenever i refresh my webpage, Views which is under my first Question (
at bottom will keep increasing.
is it possible to stop that simply increment
2. Currently being moderated.
why this message will come everytime when i Add Reply. is that msg necessary everytime.
3. showing CORRECT ANSWER image. i think we should hv option of that button to mark when user gets correct result instead of showing for every reply
tried but getting Heading value for each row
1. it's just a simple counter (I'm not sure if more intelligence would be add more value)
2. it's a security measure against spam - I don't know the exact policy but with more (no harmful) questions/answers the rules will get less restricted
3. I think it's important to highlight directly helpful/correct answers to help other users with a similar topic
- Marcus
just by refreshing counter will increase hahahahahahah
second point to be noted but need to wait till moderation completes very sad
thanks Marcus, for your answer to my general doubt