Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 dont know how to iterate over all columns of tabel ,search multiple srting .I need not only string but all the data of that cell which contain specified keyword .Please help .
Keywords = ['Appeal Allowed','Appeal failed and dismissed','Appeal dismissed','petition allowed','order accordingly','petition dismissed',
'appeal dismissed without any order as to cost','Appeal disposed of','Appeal partly allowed','Petition disposed of','No costs'] want my search based on these keywords and copy data to analysis column.
Thanx in advace.
Solved! Go to Solution.
@Ayesha_shah , 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
@Ayesha_shah , 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |