Variable length calculation in importing delimited text data wizard
When importing data only 1000 lines are used for preview.
It automatically will calculate the width of the variables based on - only the first 1000 lines???
What this can do is lead to truncation of your variable. My ID contains 12 digits for example
Can you offer a feature / tickbox where it can scan through all your data to determine the maximum length?
Basically I managed to spot this truncation but worried others would not spot it and get incorrect data.
Great software anyway, its blindingly fast. I’m stunned by its speed!
--
Daniel Froud | Senior Customer Insight & Business Intelligence Executive | HostelBookers.com Ltd
e: address@hidden | t:+44 (0)20 7440 4936 | f:+44 (0)20 7406 1801
a: 52-54 High Holborn, London, WC1V 6RL
Registered Number: 2841908 England
P Travel safely & responsibly. Please consider the environment, before printing this email
This email is from Hostelbookers.com Limited. Registered office: 52-54 High Holborn, London, WC1V 6RL, UK. Registered in England under Company No.: 2841908. This email and any files transmitted with it are confidential and may be privileged and are intended solely for the use of the individual or entity to whom they are addressed. As email can be subject to operational or technical difficulties and time delays, communications that are subject to deadlines should also be sent by post. Any unauthorised direct or indirect dissemination, distribution or copying of this message and any attachments is strictly prohibited. If you have received the email in error, please notify address@hidden