Hi
Hi do you keep the same line / row order when make power query from table. In my example, simple take fro table and delete few rows, changes the order for some reason and i need to keep it as it is.
Do you know how to solve it?
Hi
Hi do you keep the same line / row order when make power query from table. In my example, simple take fro table and delete few rows, changes the order for some reason and i need to keep it as it is.
Do you know how to solve it?
Haven't seen that behavior, but...try this:
Add an Index column before transforming the data.
Then sort the rows back into original order.
Does that help?
hi,
it helped. I had to make another query, after the first one - if I keep it in one query code, it slows down calculation significantly, up to 20 min.
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
One more thing just occurred to me.
Whenever a Power Query step seems to have mind of its own, I put a Table.Buffer step just before the problem step.
Example:
BufferData = Table.Buffer(prev_step_name)
That usually fixes it.
Does that help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks