Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Assign Pre space in specific value in inline load

Hi Friends,

Can i include pre spaces in my specific value in inline load.

3 Replies
Anil_Babu_Samineni

Where are you trying this? Can you help us to understand better

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Digvijay_Singh

Something like this may be, I used @ symbol, you may use any other, not sure if there is other way

Load ITEM,Replace(WEEK,'@',' '), Sales inline [

ITEM, WEEK, Sales

"10001", @@@@WEEK1, 100

10001, WEEK2,0 ];

jonathandienst
Partner - Champion III
Partner - Champion III

If you mean you want to load the data with the preceding or trailing blanks, then use the Verbatim system variable.

Set Verbatim = 0; // default

Causes QV to strip leading and trailing blanks from data fields (default behaviour)

Set Verbatim = 1;

Causes QV to not strip leading and trailing blanks from data fields

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein