Retain column type after expanding table

ysherriff · January 3, 2023, 10:33pm

Hi all,

I added a new column which is a table in power query and when I expand the table, the previous data types were all changed. How can I ensure the data types stays the same after expanding the table? Do in need to use Table.TransformColumns?

Before adding column:

After adding column

Thank you for your help.

Melissa · January 4, 2023, 10:29am

Hi @ysherriff,

See if this works for you

Or explore Value.ReplaceType as illustrated here

ysherriff · January 6, 2023, 2:00pm

Like always Melissa. You are a gem.

Much appreciated.