%%dvmd{TABLE WITHOUT ID choice(key = "Link", "Link", choice(key = "Rating", "Rating", choice(key = "Description", "Description", choice(key = "Type", join(Type, ", "), choice(key = "Categories", "Categories", choice(key = "Author", "Author", choice(key = "Founders", "Founders", "Created"))))))) AS "Property", choice(key = "Link", Link, choice(key = "Rating", Rating, choice(key = "Description", Description, choice(key = "Type", join(Type, ", "), choice(key = "Categories", join(Categories, ", "), choice(key = "Author", Author, choice(key = "Founders", join(Founders, ", "), created))))))) AS "Value" FROM "{{file_path}}" FLATTEN ["Link", "Rating", "Description", "Type", "Categories", "Author", "Founders", "created"] AS key}{properties_table}%% %%insert_dvmd{properties_table}%% | Property | Value | | ----------- | ---------------------------------------- | | Link | https://github.com/twitter/the-algorithm | | Rating | \- | | Description | \- | | \- | \- | | Categories | [[Marketing\|Marketing]], [[X\|X]] | | Author | \- | | Founders | \- | | Created | 2024-04-24 21:54 | %%end_insert_dvmd{properties_table}%% https://twitter.com/AlexFinnX/status/1688584001466875904 https://twitter.com/AlexFinnX/status/1693976477375554031 https://www.tanayj.com/p/understanding-twitters-algorithm