Forum Discussion

jPinhao's avatar
jPinhao
Icon for Advocate II rankAdvocate II
10 years ago

Detect type of column in Power Query Formula Language

I've got some query tables generated from imported data. All the data comes in as type 'Any', and I'm trying to automatically detect the type of the data in each column.   Some of the queries gener...
Need Help
thakks's avatar
thakks
Icon for Helper I rankHelper I
9 years ago

sminonese jPinhao were you guys able to work this out. Same issue i have come across where i have to detect the data type of new columns and convert accordingly.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

You can select the applicable columns and choose "Detect Data Type" on the Transform tab.

 

 

  • thakks's avatar
    thakks
    Icon for Helper I rankHelper I
    8 years ago

    I have to detect dynamically, when new columns are picked up while importing the csv file. I wish if it was that simple.