Search found 6 matches

by Rudi
Fri Apr 13, 2018 9:03 pm
Forum: Power Query
Topic: Help needed for Data Transformation in Powerquery
Replies: 2
Views: 730

Re: Help needed for Data Transformation in Powerquery

My 2 cents contribution Use the code below on this source file: Data.zip let Source = Csv.Document(File.Contents("C:\Data.txt"),[Delimiter=" ", Columns=11, Encoding=1252, QuoteStyle=QuoteStyle.None]), #"Removed Other Columns" = Table.SelectColumns(Source,{"Column1&...
by Rudi
Fri Apr 13, 2018 8:35 pm
Forum: Power Query
Topic: Check all columns
Replies: 3
Views: 359

Re: Check all columns

See this useful article on the subject by Chris Webb.
by Rudi
Fri Apr 13, 2018 8:27 pm
Forum: Power Query
Topic: Missing Data Source Connection
Replies: 2
Views: 361

Re: Missing Data Source Connection

It seems to me (from your screenshot) that you do not have the latest version of PQ? For the past few months, PQ has also had "Column From Example" and "Invoke Custom Function". I do not see these in your screenshot? Maybe try running Windows/Office Updates? This will also probab...
by Rudi
Tue Feb 27, 2018 10:19 pm
Forum: Power Query
Topic: Get start and end date of the current and last semester of the calendar year
Replies: 1
Views: 725

Re: Get start and end date of the current and last semester of the calendar year

A very rudimentary way... I started with a single column table with a column of dates (with heading "Order Date"), and built the rest of the output from those dates. let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnT...
by Rudi
Mon Sep 04, 2017 2:48 pm
Forum: Power Query
Topic: Table merging
Replies: 8
Views: 2841

Re: Table merging

I agree completely that Matt's method is better and more optimal. His method worked for me the first time round but the only reason why I posted a different method is that the OP mentioned they were getting errors so maybe a different approach could have help them.

Cheers :)
by Rudi
Fri Sep 01, 2017 4:51 pm
Forum: Power Query
Topic: Table merging
Replies: 8
Views: 2841

Re: Table merging

Hi Yeders, This is an old thread, but for the sake of others reviewing it and if the rare event that it's still not resolved :o Try this M-Code: let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Unique Colu...

Go to advanced search

cron