Forum Discussion
Need help with function to get column types
Hi jaryszek ,
I'm not sure what your requirement exactly is, i.e. what you want to do with that type facet "Int.64 Type", as the Power Query engine itself will ignore it.
More background info on that here: Power Query M Primer (Part 17): Type System II – Facets | Ben Gribaudo
If I know what you want to do exactly with it, I might be able to search for a solution.
Please read the article thoroughly and pay attention to the difference between ascribing a type to a value and transforming a column and let me know which of it you need.
ImkeF thank you Imke.
Ok so i understand that Power Query will ignore not primitive types and will result only primitve ones like number.
the task is simple, i have string Int64.Type in another table and if i will pass to the function i want to get exactly Type Int64.Type , not number.
If this is not possible hmm, so how Power Query knows to use Int64.Type ?
Best,
Jacek
Hi jaryszek ,
I cannot help you any further here, unfortunately.
So hopefully someone else will pick this up.Than you ImkeF . You cannot help because it is not possible in this case or you do not have skills to do this or do not have time?
Sorry for asking but i will have to push this topic later so i would like to know why is so difficult?
Thank you for trying!
Best,
Jacek
