Page 4 of 5 FirstFirst ... 2345 LastLast
Threads 61 to 80 of 82

Forum: ETL PQ Tips and Tricks

Extract, Transform, Load Tools, Power Query, Power Pivot and Power BI Tips and Tricks

  1. Cool Sticky Thread Sticky: more about PowerQuery aka Get&Transform (links)

    Started by sandy666, 06-10-2020 07:43 PM
    • Replies: 0
    • Views: 10,869
    sandy666
    06-10-2020, 07:43 PM Go to last post

  1. Cool PQ - UnZip an use Content in Power Query

    Started by sandy666, 05-13-2020 05:37 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 3,187
    sandy666
    05-13-2020, 05:37 AM Go to last post

  2. Cool PQ - Merge two tables with subtraction

    Started by sandy666, 05-12-2020 01:49 AM
    • Replies: 0
    • Views: 1,455
    sandy666
    05-12-2020, 01:49 AM Go to last post

  3. Cool PQ - table reorganization

    Started by sandy666, 05-11-2020 04:57 AM
    • Replies: 0
    • Views: 1,502
    sandy666
    05-11-2020, 04:57 AM Go to last post

  4. Cool PQ - Sort ascending values by minimum value from each group

    Started by sandy666, 05-11-2020 04:21 AM
    • Replies: 0
    • Views: 1,613
    sandy666
    05-11-2020, 04:21 AM Go to last post

  5. Cool PQ - Random questions limited (52)

    Started by sandy666, 05-11-2020 04:11 AM
    • Replies: 0
    • Views: 1,784
    sandy666
    05-11-2020, 04:11 AM Go to last post

  6. Cool PQ - Number grouped rows

    Started by sandy666, 05-11-2020 12:45 AM
    • Replies: 0
    • Views: 2,213
    sandy666
    05-11-2020, 12:45 AM Go to last post

  7. Cool PQ - How much was sold in an hour

    Started by sandy666, 05-11-2020 12:30 AM
    • Replies: 0
    • Views: 1,638
    sandy666
    05-11-2020, 12:30 AM Go to last post

  8. Cool PQ - Remove columns contain null on the end

    Started by sandy666, 05-10-2020 02:34 AM
    • Replies: 0
    • Views: 1,804
    sandy666
    05-10-2020, 02:34 AM Go to last post

  9. Cool PQ - Details for selected country

    Started by sandy666, 05-10-2020 02:12 AM
    • Replies: 0
    • Views: 1,636
    sandy666
    05-10-2020, 02:12 AM Go to last post

  10. Cool PQ - Return label and header for max value

    Started by sandy666, 05-10-2020 12:11 AM
    • Replies: 0
    • Views: 1,828
    sandy666
    05-10-2020, 12:11 AM Go to last post

  11. Cool PQ - Running Total start over

    Started by sandy666, 05-09-2020 11:05 PM
    • Replies: 0
    • Views: 1,639
    sandy666
    05-09-2020, 11:05 PM Go to last post

  12. Cool PQ - Expand dates from first to last

    Started by sandy666, 05-09-2020 10:38 PM
    • Replies: 0
    • Views: 1,769
    sandy666
    05-09-2020, 10:38 PM Go to last post

  13. Cool PQ - Total hours in decimal format

    Started by sandy666, 05-09-2020 10:15 PM
    • Replies: 0
    • Views: 1,748
    sandy666
    05-09-2020, 10:15 PM Go to last post

  14. Cool PQ - Count word in record

    Started by sandy666, 05-09-2020 09:44 PM
    • Replies: 0
    • Views: 1,750
    sandy666
    05-09-2020, 09:44 PM Go to last post

  15. Cool PQ - Risk rank

    Started by sandy666, 05-09-2020 09:36 PM
    • Replies: 0
    • Views: 1,841
    sandy666
    05-09-2020, 09:36 PM Go to last post

  16. Cool PQ - Get actual worksheet functions list

    Started by sandy666, 05-09-2020 09:32 PM
    • Replies: 0
    • Views: 2,031
    sandy666
    05-09-2020, 09:32 PM Go to last post

  17. Cool PQ - From trash to 1NF

    Started by sandy666, 05-09-2020 09:16 PM
    • Replies: 0
    • Views: 1,721
    sandy666
    05-09-2020, 09:16 PM Go to last post

  18. Cool PQ - Count selected day between dates

    Started by sandy666, 05-09-2020 09:03 PM
    • Replies: 0
    • Views: 2,007
    sandy666
    05-09-2020, 09:03 PM Go to last post

  19. Cool PQ - Median of dates

    Started by sandy666, 05-09-2020 08:51 PM
    • Replies: 0
    • Views: 3,141
    sandy666
    05-09-2020, 08:51 PM Go to last post

  20. Cool PQ - Consolidate two tables

    Started by sandy666, 05-09-2020 08:03 PM
    • Replies: 0
    • Views: 1,159
    sandy666
    05-09-2020, 08:03 PM Go to last post
Page 4 of 5 FirstFirst ... 2345 LastLast

Forum Information and Options

Moderators of this Forum

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules