Hi ,
I faced the issued of the following error and may i know how can i fix the error below:
Hi @SH_94,
If you have csv file you need to change the limit of signs in the input file. The field length column from the screen below:
Hi @SH_94
The field length setting is usually on your text files, there is another option to open the file as flat ASCII which will give you a file layout screen to set the length along with a couple of other options. It can also help to open them up in Notepad++ and look for issues with delimiters - I've found that truncated warnings on import are sometimes due to a missed delimiter on the source file or due to header/footer data that falls outside the file structure and has no delimiter.
Cheers.
@SH_94 I usually do this: If it is not CSV, conver to CSV then enlarge the field length.
Hi @ Emil_Kos
May i know when we need to use 1000 for the field length? Is it only for th format CSV?
I encounter one issue as shown screenshot below whereby the left hand side options only from 1 to 7 . May i know if this is fine and how should i fix it if not fine in this case?
I also attached another screenshot below for other file imported.
