Notifications
Clear all
Topic starter
Hi,
i have table :
and now i want to replace null value in column with column headers from second table (Table2).
So create list using Table.ColumnNames function (which is not working for me, how to implement) including types for column (like text, logical etc.).
And output as concatenated string like "{Col1, type logical}, {Col2, type Int64}, {Col3, type text}") in place of "null" value.
How to do this?
Best,
Jacek
Posted : 09/03/2021 5:35 am
Can you explain what the resulting table should look like, and why?
Posted : 09/03/2021 9:43 am
Topic starter
Hi Velouria,
thank you.
so for null i have column types from seperate table.
I just need it to create power queries on the fly with VBA.
Posted : 09/03/2021 10:44 am
You could do something like this, using Table.Schema in a function.
Posted : 09/03/2021 11:30 am
Topic starter
thank you very much !
This is what i wanted
Best,
Jacek
Posted : 10/03/2021 6:33 am