Lars Ole Sørensen
Member
Hi
I am wondering if it is possible via the power Query editor to do the following. In a new column (Fish species) extract keyword from the column "beskrivelse" based on if it contains a keyword that is included in the table "FishSpecies_Table". I have done this for one keyword "Torsk" with the formula "Text.Contains", but this is with hard coded text. Is there a way to look up the keyword in the column "beskrivelse" and if a match put the keyword in the column "Fish Species".
I will be very greateful on any help on this problem
I have attached the workbook with my temporary query.
Kindly Regards
Lars Ole
I am wondering if it is possible via the power Query editor to do the following. In a new column (Fish species) extract keyword from the column "beskrivelse" based on if it contains a keyword that is included in the table "FishSpecies_Table". I have done this for one keyword "Torsk" with the formula "Text.Contains", but this is with hard coded text. Is there a way to look up the keyword in the column "beskrivelse" and if a match put the keyword in the column "Fish Species".
I will be very greateful on any help on this problem
I have attached the workbook with my temporary query.
Kindly Regards
Lars Ole