Forum Discussion
Dynamically delete column names
Anonymous if you share a sample excel file (remove sensitive information) and what columns you want to remove or keep, provide the rules, will get you the solution.
Thank you!!
Model 1: I want to remove those column that have Budget - starts in DX
Model 2: I want to remove those column that have Budget - starts in DW
Let me knw if this gives you clarity. Thank you!!!
Not an image of parts of a worksheet, the actual workbook, that can be uploaded to OneDrive, BOX or the like, and shared anonymously. Please then reply with the sharing link.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Gotcha, thanks.
Here you will find the initial data set. And now here you will find an updated version that will replace the previous data set. As you can see two columns were added: One in the middle of the data set, and one at the end. I want to dynamically delete those columns that have "Budget" but I cannot delete the last x amount of columns because the Budget Columns shift continously. Also, I cannot make a List the Source Columns because the source is the folder.
Let me know if this is more helpful. Thanks.
