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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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