Table.Addcolumn

[MikeManwaring]

Hi All
I hope someone can point me in the right direction.
I am effectively trying to create an addcolumn list and contents of those column from a second list but it does not work.
Is there any resources i can read to achieve this result?
many thanks
Mike

 

[Ken Puls]

Hi Mike,

Do you have a small sample you can upload, and can you include a table with the format you want at the end? (Only needs to be 6-10 rows, but would make it a lot easier to figure out what you are trying to accomplish.)

Thanks!

 

[MikeManwaring]

Hi Ken
thank you for the response.
I don't have a particular table but i will explain further.

If i have a query of say 5 columns and i know that the output needs a static 25 columns of data, even if some of these columns are blank.
what i was trying to do was create a list which consisted of the column names.

myNewColumns
A
B
C
D
etc

myNewColumnContents
null
null
test
156
etc

and based on the formula

Table.AddColumn(table as table, newColumnName as text, columnGenerator as function, optional columnType as nullable type)

I tried Table.AddColumn(#"previous step", myNewColumns, each myNewColumnContents) which gave an error.

Any ideas or have you already done this?

Regards
Mike

 

[Pecoflyer]

Hi

I think Ken meant you to upload a sample file ( showing what you have and expected results)

Have a look at this to see how it works

 

[MikeManwaring]

Here is an example as requested
Thanks

Mike



View attachment example.xlsx

 

[Bill Szysz]

Hi Mike,
Try this solution below

Regards

 

[MikeManwaring]

Thank you Bill, that works great.

 

[Ken Puls]

Beat me to it, Bill. I was thinking something along the same lines there.