Forum Discussion
Dynamically delete column names
Hello everyone, I am trying to dynamically delete column names. Background on my query: my source is linked to a sharepoint folder that contains multiple Excel sheets and I upload a new one ever...
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!!!