Forum Discussion
quary
Hi, I have an unstructured csv file.Which has 490 (un_named) columns ,want to search keywords on basis of these keywords extract similar data and copy to new columns(search in all columns) .But...
Anonymous , I doubt there is multicolumn search.
One option is to unpivot the these columns to row and then use search in measure or text search visual
Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11 #PowerBI
amitchandak
Super User
Super UserAnonymous , I doubt there is multicolumn search.
One option is to unpivot the these columns to row and then use search in measure or text search visual
Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11 #PowerBI
I want to search over all columns like columns:colums without any name of column.any method in power bi *columns ect.