Qlikview tips - how to escape characters and space LOAD INLINE table
When you load a table using LOAD * INLINE, and need a space at the end of a string. Then you will find it is impossible to have a space like below in the red highlight part:
LOAD * INLINE [
FieldName
A
A-B-C
B
];
And you can get it by using replace() function like below:
LOAD Replace(FieldName,'$',' ' )as FieldName INLINE [
FieldName
A$
A-B-C
B
];
This replace() function can also be used to escape "]" or other characters. Really handy and smart design.
LOAD * INLINE [
FieldName
A
A-B-C
B
];
And you can get it by using replace() function like below:
LOAD Replace(FieldName,'$',' ' )as FieldName INLINE [
FieldName
A$
A-B-C
B
];
This replace() function can also be used to escape "]" or other characters. Really handy and smart design.
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Qlikview, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on Qlikview. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Free Demo Contact us:
Name : Arunkumar U
Email : arun@maxmunus.com
Skype id: training_maxmunus
Contact No.-+91-9738507310
Company Website –http://www.maxmunus.com
Very Informative blog thank you for sharing. Keep sharing.
ReplyDeleteBest software training institute in Chennai. Make your career development the best by learning software courses.
msbi training in chennai
devops training in chennai
php training in chennai
It has been simply incredibly generous with you to provide openly
ReplyDeletewhat exactly many individuals would’ve marketed for an eBook to end
up making some cash for their end, primarily given that you could
have tried it in the event you wanted.
oracle dba training in chennai
java training in chennai
node js training in chennai
Your good knowledge and kindness in playing with all the pieces were
ReplyDeletevery useful. I don’t know what I would have done if I had not
encountered such a step like this.
oracle dba training in chennai
java training in chennai
node js training in chennai