To overcome this, you can convert your Outlook exported CSV into. A simple script to convert data in CSV format to iCal format and vice versa. feel free to continue cleaning up your columns from here. Currently, we are unable to import CSV file exports from Outlook. To convert a CSV file into an ICS file, open the CSV-to-ICS Converter tool, select the CSV file to convert, and then select the name of the ICS file to be. as I can't be sure in which order your columns are going to be transposed, I stopped at the split column step. ics To Csv here is video on how to convert ics calendar file to text csv (comma separated values) If you want to automate conversion or avoid user Interface (UI) and run 'ics To Csv' application from command line - here is an example of how to do it: 'C:Program Files (x86)WhiterockSoftwareicsToCsvicsToCsv.exe' MyiCalExport. Add a custom column with the formula Table.Transpose ( all) expand that column keeping only the fields you want. Let's call the result of that operation column all. The trick is not to use the default Line.FromBinary and Table.FromColumn options but instead treat the input as one huge blob of text and then go to town on slicing it based on the Begin:VEVENT occurrence, then unpivot the data and finish cleaning it up. Group on that column and don't aggregate (choose All in the drop-down). I know this answer is two years over due, but here is some powerbi magic that can solve this issue.
0 Comments
Leave a Reply. |