Keep leading zeros when importing from folder?

[Anonymous]

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.

[Vvelarde]

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)

[Vvelarde · Accepted solution]

@Anonymous

Another solution would be:

Just modify this: Change the type from Int64 to text in this Query;

[Anonymous]

@Vvelarde

Thank you! Worked like a charm!

[Anonymous]

@Vvelarde

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. 

[Vvelarde]

@Anonymous

Hi, please follow the steps in this video, i think is a faster solution than previous.

[Anonymous]

@Vvelarde

Strange, when I click on the dropdown I didn't get the CSV popup box where he changed it to semicolon delimiter. Skipped that step

[Vvelarde]

@Anonymous

I think is my regional configuration, my separator is semicolon. If use a comma in CSV that window don't appear.