quary

[Ayesha_shah]

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.

[amitchandak · Accepted 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 want to search over all columns like columns:colums without any name of column.any method in power bi *columns ect.