https://community.qlik.com/t5/Connectivity-Data-Prep/txt-data-loading-with-quot-space-quot/m-p/1538228#M3586 are you loading CSV file? , can you post youe sample data? Fri, 01 Feb 2019 05:37:25 GMT agni_gold 2019-02-01T05:37:25Z https://community.qlik.com/t5/Connectivity-Data-Prep/txt-data-loading-with-quot-space-quot/m-p/1538226#M3585 <P>Hi&nbsp;guys</P><P>I tried to load the txt data with space.</P><P>This data is not so perfect and includs some blank in rows,</P><P>so when I load it, some data shifts to the left.</P><P>Please tell me how I can stop data shifting and load blank as one of the data.</P><P>Thank you.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rapture_20190201142537.jpg" style="width: 920px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5001i4F4FC67751616CBD/image-size/large?v=v2&amp;px=999" role="button" title="rapture_20190201142537.jpg" alt="rapture_20190201142537.jpg" /></span></P> Fri, 01 Feb 2019 07:30:25 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/txt-data-loading-with-quot-space-quot/m-p/1538226#M3585 wenyan1206 2019-02-01T07:30:25Z https://community.qlik.com/t5/Connectivity-Data-Prep/txt-data-loading-with-quot-space-quot/m-p/1538228#M3586 are you loading CSV file? , can you post youe sample data? Fri, 01 Feb 2019 05:37:25 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/txt-data-loading-with-quot-space-quot/m-p/1538228#M3586 agni_gold 2019-02-01T05:37:25Z https://community.qlik.com/t5/Connectivity-Data-Prep/txt-data-loading-with-quot-space-quot/m-p/1538235#M3587 <P>No, I load .txt file.</P><P>I upload sample date. Please see this one.</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 01 Feb 2019 05:53:01 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/txt-data-loading-with-quot-space-quot/m-p/1538235#M3587 wenyan1206 2019-02-01T05:53:01Z