Chapter 8 – Record functions in power query скачать в хорошем качестве

Chapter 8 – Record functions in power query

Chapter 8 – Record functions in power query    • Chapter -6 Full M Code Power Query - Lists   #powerquerymcode #vikominstitute #completemcode 00:00:27 Understanding of records 00:01:23 Record from list in power query 00:03:00 Record add field in power query 00:05:03 Record remove field in power query 00:06:06 Record Select field in power query 00:08:10 Record field values in power query 00:10:00 Record combine in power query 00:11:32 Record to list in power query   Power query code used in video let Source = Record.FromList({1,2,3},{"A","B","C"}), RecordAddField = Record.AddField(Source,"D","Vikal Jain"), RecordRemoveFields =Record.RemoveFields(RecordAddField,"B"), RecordSelectFields =Record.SelectFields(RecordRemoveFields,{"A","D"}), RecordFieldValues =Record.FieldValues(RecordSelectFields), RecordCombine= Record.Combine({[A=1,b=2,c="vikal jain"]}), RecordToList =Record.ToList([a=1,b=2,c=true]) in RecordToList Important Links Our You Tube channel 👍👍    / vikominstitute   Our LinkedIn channel 👍👍   / jainvikal   Instagram link 👍👍   / tricksexcel   Telegram link 👍👍 t.me/exceltricks1 Excel group links 👍👍   / tricksexcel   Twitter link 👍👍   / vikalexcel   Wanna Paid courses 👍👍 Contact whatsapp +91-9213331108 or email [email protected]