topic Re: Assign Pre space in specific value in inline load in QlikView

Assign Pre space in specific value in inline load

agni_gold — Tue, 30 May 2017 20:54:31 GMT

Hi Friends,

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

Anil_Babu_Samineni — Wed, 31 May 2017 02:10:56 GMT

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

Digvijay_Singh — Wed, 31 May 2017 04:45:21 GMT

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 — Wed, 31 May 2017 05:21:53 GMT

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