//Metadata: 
//Programming language: Power Query M 
//Natural language: German 
//Output: new column

//Explanation: 
//Generates a column "Unternehmensform", which clusters the company type based on a company name "Firmenname" column

//How to use: 
//Copy the code into an "add new column step"


Code:
        = Table.AddColumn(
        #"ADD UnternehmensArt",
        "Unternehmensform",
        each
            if Text.Contains([Firmenname], "enossenschaft") then
                "Genossenschaft"
            else if Text.Contains([Firmenname], "mbH") then
                "GmbH"
            else if Text.Contains([Firmenname], "UG (haftungsbeschränkt)") then
                "UG (haftungsbeschränkt)"
            else if Text.Contains([Firmenname], "eG") then
                "eG"
            else if Text.Contains([Firmenname], "AG") then
                "AG"
            else
                "Sonstiges"
    	)