Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@Anonymous
Another solution would be:
Just modify this: Change the type from Int64 to text in this Query;
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.
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
@Anonymous
I think is my regional configuration, my separator is semicolon. If use a comma in CSV that window don't appear.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |