Hellmar Becker’s Post

Unpivoting data with "M-Code" 🤔 You must have Unpivoted your data lots of time with power query but with its User-Interface. We all use power query's Unpivoting feature to unpivot the data but there are times when you have to use "M-Code" to Unpivot your data. For instance ,You have multiple headers then you need to use a bit of "M-Code" to unpivot your data. Of course! This data is very simple to unpivot but I have just shared my approach of solving this and there could be far better solution than than this. I have used both bit of Formula editor and custom column to unpivot this data but have not used User-Interface. ⬇ #powerquery

Quick tip - DDL for vector indexes https://lnkd.in/gwtNtE_r

Updated the 'Unofficial GA4BigQuery schema change log' to reflect today's schema changes: https://lnkd.in/e-w6ciwv

Regex Modes for XLOOKUP and XMATCH: GET YOUR FUZZY (MATCH) WARM FEELINGS HERE!! OK, so not in all versions of Excel yet, but in Preview in the Beta channel comes an addition to match_mode which allows you to seek out regular expression patterns as lookup_values in your XLOOKUP and XMATCH functions. What does that mean in layperson's terms? Dynamic fuzzy matching becomes easy breezy (no Power Query merges), you can seek out rogue data and locate patterns in your data files. Check out loads of examples here: https://lnkd.in/gz2e2_hi Simples! #Excel #Regex #XLOOKUP

In SQL, a single column can reference a single table which is recommended. But let's say you want to reference not a single table but two tables. In that case you can use Polymorphic Associations design pattern. This means having a column to indicate which table the foreign key points to, along with a column for the actual foreign key value. CREATE TABLE Table1 (id INT PRIMARY KEY, name VARCHAR(100)); CREATE TABLE Table2 (id INT PRIMARY KEY, description VARCHAR(100)); CREATE TABLE PolymorphicTable (id INT PRIMARY KEY, ref_id INT, ref_type VARCHAR(50)); -- Example data insertion INSERT INTO PolymorphicTable (id, ref_id, ref_type) VALUES (1, 1, 'Table1'); INSERT INTO PolymorphicTable (id, ref_id, ref_type) VALUES (2, 1, 'Table2');

Again from a very long time i started DSA using C. Really it's Interesting Topics Like. Data Structure is Divided as -Primitive DS -Int -Float -Double -Char -Boolean -Long -Byte -Non Primitive DS -Linear -Array -Stack -Queue -Linked List -Non Linear -Tree -Graph -Hash Table The best part is we can further divide the thease as Static DS and Dynamic DS. like we can implement the DS using Array Or Linked List. when using Array it's Called Static DS. when using Linked List called Dynamic DS.

char is primitive or basic data type in C. char a[] means flexible array identifier a . If you are using a flexible array , you must initialise it. For example char a[] = “Embedkari” ; Here if you want to change the string later , you may simply add. char a[] = “Embedded with Embedkari” ; If you just want an array of characters (not string), define it as follows: char a[] = { ‘E’ , ‘m’, ‘b’, ‘e’, ‘d’, ‘k’, ‘a’, ‘r’ , ‘i’} ; The above array has no termination by NULL character. There are two char related data types : signed char and unsigned char . If you write just char , it is a signed char . signed char accepts value from -128 to +127 unsigned char accepts value from 0 to 255 . There are two user defined data types based on char . one is int8_t for char and other is uint8_t for unsigned char. If you find this information useful, don't forget to upvote. Answer to If char is not a data type, then why should we write char (char a[]) in array initialisation? by Sanjay Kumar https://lnkd.in/gAhhQYJX #embedded #embedkari #opentowork

How many tables you have in your application to present data to user? How many of them have similar amount of columns? How many of them have different ways of displaying rows or cells? Does all have selectable rows? Any other differences? DDRY. Don't DRY. Do not create abstractions for things that do not need it. Tables have abstractions already: table, thead, tbody, tr, td. You don't need table component with hundreds of options.

In a lazy query in Polars you can do a mini-query where you limit the number of rows that you read. For example to get just the first 5 rows you can call .head().collect(). This can be much faster for testing queries on large datasets

🤝 Feeling thrilled~ Published the SQL Code on Medium . . . For understanding ,Checking & Suggesting innovative trick ,click below:) . . . Happy Sharing:) . . . #data #datamining #engineering #analytics #innovation #SQL #bigdata #business #medium #linkedin #google #coding #google #collaboration #excel #tableau