How to create a Data type table

[Anonymous]

Hi All, may I know is there any way I can create a table like this(Data type for each column) in PowerQuery?

Column Name	Data Type
ID	Whole number
Name	Text
Cost	Decimal number

Thanks so much!

[ghoshabhijeet · Accepted solution]

@Anonymous  Yes, you can get the Column Name and Datatypes of the column and other informations about the schema using the below M Code.

#"Column Names" = Table.Schema("Table Name")

Once you get all the information, you can then keep whatever is required for your need and rest you can or remove.

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍