Forum

Replace null value ...
 
Notifications
Clear all

Replace null value in column with column names from sepatate table

5 Posts
2 Users
0 Reactions
101 Views
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Hi,

i have table :

 

Screenshot_135.png

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
(@debaser)
Posts: 837
Member Moderator
 

Can you explain what the resulting table should look like, and why?

 
Posted : 09/03/2021 9:43 am
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Hi Velouria, 

thank you. 

Screenshot_136.png

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
(@debaser)
Posts: 837
Member Moderator
 

You could do something like this, using Table.Schema in a function.

 
Posted : 09/03/2021 11:30 am
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

thank you very much !

This is what i wanted

Best,
Jacek

 
Posted : 10/03/2021 6:33 am
Share: