Page 1 of 5 123 ... LastLast
Threads 1 to 20 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,682
    sandy666
    06-10-2020, 07:43 PM Go to last post

  1. Cool PQ - counting rows filtered and after filtering

    Started by sandy666, 08-22-2023 09:46 PM
    1 Attachment(s)
    • Replies: 1
    • Views: 78,744
    sandy666
    09-15-2023, 10:32 AM Go to last post

  2. Cool PQ - from excel workbook with/without promote headers

    Started by sandy666, 07-31-2023 03:43 AM
    • Replies: 0
    • Views: 9,010
    sandy666
    07-31-2023, 03:43 AM Go to last post

  3. Cool PQ - Grouping rows with different data type

    Started by sandy666, 07-31-2023 01:19 AM
    • Replies: 0
    • Views: 7,854
    sandy666
    07-31-2023, 01:19 AM Go to last post

  4. Cool PQ - Grouping columns in rows and get data marked by x together

    Started by sandy666, 07-25-2023 05:30 AM
    • Replies: 1
    • Views: 9,303
    sandy666
    07-26-2023, 01:43 PM Go to last post

  5. Cool PQ (PT) - Text value in an interference matrix

    Started by sandy666, 07-13-2023 05:54 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 7,407
    sandy666
    07-13-2023, 05:54 AM Go to last post

  6. Cool PQ - Letter count in each word of text

    Started by sandy666, 07-13-2023 05:28 AM
    • Replies: 0
    • Views: 7,103
    sandy666
    07-13-2023, 05:28 AM Go to last post

  7. Cool PQ - Evaluate

    Started by sandy666, 07-13-2023 04:15 AM
    • Replies: 0
    • Views: 7,609
    sandy666
    07-13-2023, 04:15 AM Go to last post

  8. Cool PQ - Cleanup data with several conditions

    Started by sandy666, 07-13-2023 03:30 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 7,302
    sandy666
    07-13-2023, 03:30 AM Go to last post

  9. Cool PQ - multiple replacement using List.Generate()

    Started by sandy666, 07-13-2023 02:23 AM
    • Replies: 0
    • Views: 7,177
    sandy666
    07-13-2023, 02:23 AM Go to last post

  10. Cool PQ-search for data with just a few letters from a data table

    Started by sandy666, 07-12-2023 06:53 PM
    1 Attachment(s)
    • Replies: 0
    • Views: 7,291
    sandy666
    07-12-2023, 06:53 PM Go to last post

  11. Cool PQ - search item return category

    Started by sandy666, 07-12-2023 06:29 PM
    • Replies: 0
    • Views: 9,498
    sandy666
    07-12-2023, 06:29 PM Go to last post

  12. Cool PQ - restart numbering

    Started by sandy666, 07-12-2023 04:56 AM
    • Replies: 0
    • Views: 7,310
    sandy666
    07-12-2023, 04:56 AM Go to last post

  13. Cool PQ - Restart numbering with table

    Started by sandy666, 07-12-2023 04:51 AM
    • Replies: 0
    • Views: 7,419
    sandy666
    07-12-2023, 04:51 AM Go to last post

  14. Cool PQ - List Prime

    Started by sandy666, 07-12-2023 04:16 AM
    • Replies: 0
    • Views: 7,293
    sandy666
    07-12-2023, 04:16 AM Go to last post

  15. Cool PQ - Fridays between dates for whole year

    Started by sandy666, 07-12-2023 04:09 AM
    • Replies: 0
    • Views: 7,143
    sandy666
    07-12-2023, 04:09 AM Go to last post

  16. Cool PQ-How to insert comma between every character

    Started by sandy666, 07-12-2023 03:18 AM
    • Replies: 0
    • Views: 7,400
    sandy666
    07-12-2023, 03:18 AM Go to last post

  17. Cool PQ - tip of the day

    Started by sandy666, 07-12-2023 02:51 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 7,130
    sandy666
    07-12-2023, 02:51 AM Go to last post

  18. Cool PQ - simple example of List.Intersect()

    Started by sandy666, 07-12-2023 02:22 AM
    • Replies: 0
    • Views: 7,412
    sandy666
    07-12-2023, 02:22 AM Go to last post

  19. Cool PQ - transform text string to proper date

    Started by sandy666, 07-12-2023 01:03 AM
    • Replies: 0
    • Views: 7,327
    sandy666
    07-12-2023, 01:03 AM Go to last post

  20. Cool PQ-how many last rows to show determined by single row table

    Started by sandy666, 07-11-2023 08:40 PM
    1 Attachment(s)
    • Replies: 0
    • Views: 6,997
    sandy666
    07-11-2023, 08:40 PM Go to last post
Page 1 of 5 123 ... 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