Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am trying to load multiple csv file from a sharepoint folder and when this are combined the text within a particular column gets divided and creates a new row causing error in the sheet. It seems the error happens when the column contains long text that has line break between them
Snip of the sample text that gets divided.
Files are loaded from the sharepoint folder and combined in the normal ways
After these files are combined, there will be multiple rows as seen below which will be automatically created causing errors
Can someone help me with a solution for this.
Regards,
Sarath
Further to the issue, i understood, its the line break that causing the issue, i have found some threads online but i couldnt solve the issue
Hi, @sarathD4s
It is recommended to pre-clean these file data to ensure that these csv files from a sharepoint folder have the same data structure.
You can check if the following thread helps.
Best Regards,
Community Support Team _ Eason
Hi @amitchandak , thanks for the reply, but clean and trim can only done once it been loaded.
Here New rows are created when the files are loaded so there is no point using trim and and clean after that.
@sarathD4s , You can use clean and trim on a column to remove newline character, but that will happen only when it is on row
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |