on 07-27-2010 7:18 AM
I have created a new LSMW. After mapping whenever it fatches the data from the uploaded file it markes "##" symbol before and after every content of the field.
Can any one resolve and point me out the reason for the problem.
Hi Lalit,
I experienced a similar problem when i was working on the LSMW. We created an excel file using open office. The excel sheet was adding additional characters to the fields when tried reading the data. The same file we saved as a .csv or a .txt file did not give the problem.
Also make sure while you saving the source file location, make sure you maintaining the file as a tabulated separated file. You need to make sure this is taken care of. This also causes the ## characters to be seen in the read data. Every time you update the file go to this step and make sure the file is saved as a tabulated file.
This is present in step no 7 legacy data file source, and delimiter sa tabulated.
Regards,
Aditya Dhurandhar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is due to , filed in column is to large ,
Double click on first column and adjust there width to the lenght of filed in excel.
Properly convert then to tab deliminated file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The ## symbol is because of data that is present in flat file. i.e use proper delimiter.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is your source a TXT file? or did you directly enter an Excel file as source?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Fields are not properly mapped.
There is inconsistecy with LSMW fields and Fileds in file which you are using to uplaod the data.
Check the field lenghs maintained and actual fields lenths in corresponding tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.