Im refreshing excel files that are updated in a folder. Is it possible to add 2 additional columns with formulas after the table loads. The first formula trims off www.domain.com text from a URL column and the second one is an ifblank, display another column formula.
I think I can do the ifblank one with power query but I dont know how to format the URL's without RIGHT FIND LEN formulas. Also just wondering in general as I have other tables that would be easier if I could somehow reference the excel formulas after the load.
I tried putting the columns next to the power query load but it just overwrote/deleted them.
Bookmarks