Forum Discussion
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-msftCommunity 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
MaggieCommunity 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.