Forum Discussion
Solved
Indexing csv files read from directory
Hello, I’m attempting to load CSV files from a directory and would like to add an index to each of them, which would allow me to track error coordinates in the source data. After reading the direct...
Is there a method to index these CSV files while maintaining their binary form?No. At the very minimum you need to split the binary by the row delimiter (for example LF), inject the index column, and then reassemble the binary. Although at that point you might as well fully decode the files and load them into Power BI.
Is there a method to index these CSV files while maintaining their binary form?No. At the very minimum you need to split the binary by the row delimiter (for example LF), inject the index column, and then reassemble the binary. Although at that point you might as well fully decode the files and load them into Power BI.