Forum Discussion

hanxu95's avatar
hanxu95
Regular Visitor
7 years ago

Creat mutiple columns based on a column from another table

Hey guys!

 

I want to create mutiple columns in the first table with headers from the colunmn "tag_name" in table 2 
(like "1940s", "american", "funky", etc.), and then check whether the column "tags" in table 1 contain it. If yes, fill 1, if no, leave it blank. TIs there any way I can fast import the colunmn "tag_name" in table 2 as the column headers in table 1? If not, is there any fast way I can use the words from column "tags" in table 1 to create new columns and check whether "tags" contain it? I know that I can use "conditional column" button under "Add Column" but I can only create one new column at once and I have 115 tags here.

 

Thank you in advanced!

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi hanxu95 

    Do you want to compare all rows in "tag_name" to the each row in "tag",

    If the value of one row in "tag_name" can be found in one row in "tag", get a column which is 1 for this row.

     

    Is my understanding correct?

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.