Load * Inline [
left([F1],2) as F2,
left([F1],-1) as Fneg // i have a doubt what this staement does.. or what is its output.
Resident T1; // what this statement does...
try it in a text box and see for yourself
LEFT('ABCD',2) >> will return 2 character starting from left of the string, so string returned is 'AB'
LEFT('ABCD',-1) >> will return null as string starts from position 1
what about Resident statement...
You can find a lot of content just be searching the community for the related topic
Space Search | Qlik Community
You can find examples for all functions in Qlikview help
Retrieving data ...