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 "t...
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.