Date for all rows

Hi Anonymous 

I'm guessing you've used the Folder connector and selected Combine & Transform Data

And you have a set of helper queries like this

Create a new query again using the Folder connector but this time select Transform Data

Select the columns you want to keep, I've used projection to keep these cols: [[Date created], [Content]]

Now you can invoke the Transform file custom function query on the Content column

Table.ReplaceValue(Source,each [Content],each #"Transform File"([Content]),Replacer.ReplaceValue,{"Content"})

OR

If the date you require is in the Content table and has a fixed place (row and column), try this:

1. Add a Custom Column
2. Bring in the Content table: [Content]
3. Refer to the zero based row number: {2}
4. And the field name that contains the date: [Company Name]

Now when you expand the Content column it will have that value on each row.

Ps. If this helps solve your query please mark this post as Solution, thanks!