Applying Extract Data before delimiter to a dynamic number of columns RRS feed

  • Question

  • I have a template that pulls from an external folder housed on a network drive. The data is always in the same format, but there is one data field (Rotations) that could vary from report to report (some reports may have 1 and some can go as high as 30).

    I am looking to utilize the "Extract Data before a delimiter" functionality to pull all data which precedes the second comma in the data set.

    However, I cannot figure out how to rewrite the M code to apply the Extract Data functionality to a dynamic number of columns with the word "Rotation" in the header row.

    Any suggestions?

    Wednesday, April 4, 2018 6:53 PM