Forum Discussion
Need best way to automatically transform text file to Excel with specific data types
I have two large employee detail text files (300+ data columns, 12,000 + records for each) generated daily from an HRIS program, one for active personnel and one for terminated personnel effective wi...
Hi Mark,
If your text files structure is always the same it'll be one time job to adjust/transform your columns and generate the resulting file with Power Query, after that only refresh the result with each new pair of text files.
Will definitely explore that option - thanks Sergei!
