Forum

Hi Mike, data in PQ isn't stored in a consistent state - that is, the view you see of the data and the way PQ is actually storing it, isn't necessa...

Hi Tina, Can you please supply the XML? Without this it's hard to give you anything other than general guidance. When you have a column full of...

Hi Venkata, Please supply some sample data showing the way the data and headers are mixed in your table following import by PQ. Without this it'...

Hi Hassanin, Please supply a file with some sample data, showing the exact column names and layout you will be using. Without this any code that i...

Nothing attached. Click the Start Upload button after selecting the file(s).

Hi RaiSta, You could try if Text.Length(<txt>) > 0 then Text.Start(<txt>, MAX(0,Text.Length(<txt>)-1)) else null Regards...

Hi Nivian, Nothing is attached - you need to click on the Start Upload button to upload the file(s). What version of Office are you using? Ar...

Hi Keith, Looks like the account being used to access the file does not have the required permissions to do so. If you've just moved everything ...

Hi, Try this Sub SortCols() ActiveSheet.ListObjects("Table1").Sort.SortFields.Clear Range("Table1").Sort Key1:=Range("Table1[[#All],[Col3...

No worries Chloe.

Hi Johnson, In the query I don't see any step that tries to Fill Down. I also don't see where you tried to replace ' as blank. And if I search th...

Hi Chloe, There's no file attached, you need to click on Start Upload after selecting the file. But, I think what you are trying to do can be do...

Hi Chloe, Can you please provide some sample data and explain how you know some links are wrong and when/why an error will occur. Without these ...

Hi Richard, I'm not sure if you are appending or merging data, it'll depend on the structure of our tables. But you could try something like this ...