Forum Discussion
Keep leading zeros when importing from folder?
Hi,
I am importing many .csv files from a folder at once. There is one column that has leading zeros and I am losing them even when I change column to text. Do I have to manually load each one and merge?
Not sure if there is another way to do this, but i just clicked on the double drop down arrows next to content to auto merge them.
Anonymous
Another solution would be:
Just modify this: Change the type from Int64 to text in this Query;
7 Replies
hi Anonymous
Try this, Select Data Type Detection: Do not detect data types
After that, select first row as header and apply a filter (The other headers from csvs)
Anonymous
Another solution would be:
Just modify this: Change the type from Int64 to text in this Query;
Can you show me the steps of how to get to that point you're showing? I use the drop down arrow next to content and it automatically "Invokes Custom Function" and everything is merged.
Anonymous
Hi, please follow the steps in this video, i think is a faster solution than previous.