Creat mutiple columns based on a column from another table

[hanxu95]

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!

[v-juanli-msft]

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.

[hanxu95]

Hi Maggie,

Do you have any idea how I can do it?

[hanxu95]

Hi @v-juanli-msft ,

Thank you so much for your reply! That's correct!