Hi Ruth, did you check the effect on query folding? In my experience “Merge columns” broke it, whereas Excel-style concatenation was passed on to an SQL server.
@CurbalEN3 жыл бұрын
Aha, that I havent tested. The M function used is not the same as the Right click 》 merge, so fingers crossed it doesn't break? Let us know if you test it!
@ferdinandsantos66803 жыл бұрын
Thanks for sharing Ruth! Always learning new things from you.👍🏼 Just want to point out a difference between the two methods. The second method omits the leading comma in row 5 (Bike,8). This will matter when the merged column is split back into columns as Bike will end up in the first column. So the choice between the two methods depends on what the merged column will be used for subsequently.
@CurbalEN3 жыл бұрын
You can add that manually if needed and replicate the first method exactly 😊
@ThGrum3 ай бұрын
Exactly what I was looking for. Thank you so much 👋
@thomasivarsson24683 жыл бұрын
Null is a nonexisting value so it cannot have a data type. Concat Null yeilds Null is the default in databases. I did not know the trick of merge on 3 different columns. Great!
@CurbalEN3 жыл бұрын
Thanks Thomas, that explains it :)
@jayraldtajale81219 ай бұрын
Thank you for sharing this I already concatenated the columns regardless if there’s a null values.
@guillermochavez72753 жыл бұрын
Nunca dejes de compartir tus videos de trucos con PQ, los amamos. Gracias.
@CurbalEN3 жыл бұрын
Si, no te preocupes. Siempre que aprenda un truco nuevo lo mostrare aqui :)
@mgvivi3 жыл бұрын
Hi, i not speak english, but i like your video, is amazing. Thanks a lot. Me ayuda mucho con mi trabajo. Saludos de Perú
@CurbalEN3 жыл бұрын
Me alegra oirlo :)
@sebastiencrepel5032 Жыл бұрын
Hello Ruth. Your channel is a real gold mine ! Thank you for all this valuable work.
@CurbalEN Жыл бұрын
Thanks 🥳
@gabrielpugas7 ай бұрын
Perfect presentation! Thank you
@shaddwatson18332 жыл бұрын
Hello Ruth, your videos have helped me professionally numerous times and for that I would like to thank for all you do! Keep up the great work.
@CurbalEN2 жыл бұрын
And thanks for the feedback!!
@elisafolletti50603 жыл бұрын
Thanks Ruth. It seems that the result of merge and that of combine are not completely the same; in the first case ",Bike,8" in the second "Bike,8"
@CurbalEN3 жыл бұрын
You can fix that adding the , manually :)
@AlvaroPerez-ox7ul2 жыл бұрын
Best channel on this so far.
@CurbalEN2 жыл бұрын
Thanks!
@philipkimani1262 Жыл бұрын
Thank you so much for sharing this knowledge. It worked with my data.
@fabienperon30652 жыл бұрын
hi thanks. How to merge columns when we ignore numbers ok column ?
@NicoChin4 ай бұрын
Thank you verry much
@akshitmehta2680 Жыл бұрын
Hi Ruth, I need to do the same but with numbers instead. I have two columns with numbers and I need to combine and add numbers from both columns to the new added column :( can't figure it out
@jensnystrom8250 Жыл бұрын
Hej Ruth! If I have multiple columns like the "Custom" in your video here but I want to split them out? I have column 1-5 that have a kg &value merged that represents scales but now want to split column 1-5 out to 1 - KG & 1 Value, 2 - KG & 2 - Value - any idea of how to do this? Split columns can be used obvs but generates multiple steps - is there a way to do it in one?
@jayasreecarey78432 жыл бұрын
Thanks a lot ! was looking for the exact requirement
@adityasinha51673 жыл бұрын
Thanks for the video! it solved the problem :). Do you have a way to add images into tabular from Excel directly or images stored locally
@norbertschmidt65323 жыл бұрын
Dear Curbal or should I say Ruth, please tell me. Thanks for the video. GREAT. I didn't know before. Hope to see more of your videos.
@CurbalEN3 жыл бұрын
Hi Norbert, Curbal is me, so either works and glad it was useful!
@mehdihammadi61453 жыл бұрын
Thanks for the reminder Ruth, as always simple and efficient
@CurbalEN3 жыл бұрын
I too have to remind myself to stay away from &... Habits die hard!
@abhishekstatus_73 жыл бұрын
Thanks for sharing this Ruth !! Really amazing concept !!
@navzme3 жыл бұрын
Perfect. Exactly what I was looking for. Thanks
@CurbalEN3 жыл бұрын
🥳
@googlegoogle-gg3dp11 ай бұрын
I have 1 m record on which I want to apply group by to get max value of each category and then same value should reflect against each category in separate custom column.....I tried it but it will take almost 2 hours and eventually system hanged....any suggestions pls
@irinasultani45252 жыл бұрын
Big thank you !
@alterchannel2501 Жыл бұрын
thank you so much for this
@Unbox7473 жыл бұрын
Nice, short and sweet!
@CurbalEN3 жыл бұрын
That is how we like it :)
@godfreykiggundu7787 Жыл бұрын
Wow!!! Wonderful
@xodrinker3 жыл бұрын
Highly educational. Thx Ruth 👍
@CurbalEN3 жыл бұрын
Perfect!
@Jugulator313 жыл бұрын
This solved my problem - thanks Curbal! Your channel is amazing ;)
@CurbalEN3 жыл бұрын
Wonderful to hear!
@Bluesun07142 жыл бұрын
Thank you for sharing the great tips.
@dinoroy8962 Жыл бұрын
so nice, thank you...
@MrSpiritUAll3 жыл бұрын
Nice midweek vlog❤️. See you friday🥂
@CurbalEN3 жыл бұрын
With another DAX Fridays!! 😀
@indykoncepts28789 ай бұрын
Thank you 🙏
@paspuggie483 жыл бұрын
Now I know 😀. Cracking solution again Ruth 👏👍
@CurbalEN3 жыл бұрын
Thanks Paul :)
@txreal22 жыл бұрын
Thanks for the video. I've been struggling to find a way to concatenate parts of 3 columns to create a primary key in PQ. For ex: first 4 of Last Name, first 4 of First Name, and DOB. Any help is appreciated.
@RonoyPaul2 жыл бұрын
Great thankful 🤗
@mahathmasadineni28843 жыл бұрын
I have a question here if you see last rows when there is some blank rows or nulls are not coming properly do have any vedio to solve the issue
@CurbalEN3 жыл бұрын
It depends on what your business logic is. Post some sample data in the power bi community to get personalized help
@mahathmasadineni28843 жыл бұрын
@@CurbalEN thank you for your response. I will watch every day 2 vedios of you to learn a something new. Great job madam. Keep it up.
@CurbalEN3 жыл бұрын
Then soon you will know as much as I do :)
@Milhouse77BS3 жыл бұрын
3:25 I notice same problem with nulls involved in date calculations. I try to convert nulls to zero or empty string if use in adding a column.
@CurbalEN3 жыл бұрын
I have been dealing with dynamic tables where I dont know how many columns will load so I need to avoid hardcoding column names. This quick trick does it:)
@vineetyoutubr53 жыл бұрын
Really helpful. thanks, Ruth
@apurvamaheshwari80253 жыл бұрын
Hi Ruth Please help me urgently , I created a calculated column in one table but the same isn't appearing when I'm trying to merge it as query to another table. How to resolve this?
@dianayang-manzana77123 жыл бұрын
Hi Ruth, I've been watching loads of your vides and find them very easy to follow. Thank you! I am hoping you can help me with the following : I have a headcount data set with over 30,000 recorded for both employees and contractors combined. There are HQ County, HQ State, Work County and Work State in the dataset. I used what you shown to combine HQ County + HQ State and Work County +Work State as 2 new columns. But Power BI ended up freeze when I used the Flow Map which I think it's due to record numbers. Any suggestion on how to approach this for Mapping? Will it work if I create another table with only HQ/Work data and link to the original data ( like in another of your video) and use it for Map? Please help~ thank you~~
@FirmanMaulanaAditya3 жыл бұрын
[Expression.Error] We cannot apply operator & to types Text and Number. can you help me? i got error like this, i've been change duplicate date to number but i just got like that
@FirmanMaulanaAditya3 жыл бұрын
i used automatic not manual merge column
@simonferns94873 жыл бұрын
How do I concatenate 2 number values into one column? (Without deleting the original ones - NOT merge). I always get the null error
@simonferns94873 жыл бұрын
Let’s say: 3078 and 2020. The desired value is 30782020
@haydeemera66313 жыл бұрын
Thanks Ruth.
@dannyhometown3 жыл бұрын
Thanks Ruth, Good one Text.Combine. Marked. :P
@CurbalEN3 жыл бұрын
Saving me from a lot of trouble lately :)
@raheem0046 Жыл бұрын
Item5: result should have been ",Bike,8" instead your results were"Bike,8" which is still not correct. I may be wrong, correct me if am
@mariaalcala51593 жыл бұрын
Thank you very much! I was wondering if you could use this function to create CSV files. With macros you need to do a lot of looping. Would it be possible?
@StefanoVerugi2 жыл бұрын
sort of alternative to the methods shown here you could merge the row into a record, convert it to list and combine values with a comma I tried with a simple table and it correctly put all the "," as separator,to avoid type error before adding the column format all columns as text = Table.AddColumn(#"Previous step/query", "Custom", each Text.Combine(Record.ToList(_),",")) once you export it to Excel as a table, you can use the 'Text to Columns' option in data tools and save it in CSV format PS if you have null values select columns and use Replace Values in Transform (null to empty cell) before hope it helps
@diegolozano23972 жыл бұрын
thanks a lot
@IlariaLongoDorni3 жыл бұрын
Thanks for suggestion
@suryasahoo37713 жыл бұрын
Thanks Ruth
@bandipragnyank2038Ай бұрын
This is a complex process
@ringovski19803 жыл бұрын
Null is a column of unknown data type, a blank column is a empty string or other type.
@CurbalEN3 жыл бұрын
Thanks!
@MrDhunpagla3 жыл бұрын
It is wonderful 😇😇😇😇 Thanks
@CurbalEN3 жыл бұрын
It is once you get the habit to use it:)
@erickadx82693 жыл бұрын
Gracias!
@Acheiropoietos3 жыл бұрын
So&" "&helpful&", "&thank&" "&you&"."&"
@CurbalEN3 жыл бұрын
😊😊
@totvabe13 жыл бұрын
Missing your forest environment … 😥
@CurbalEN3 жыл бұрын
Going up there next weekend, will do some intros outside again:)
@fxsignal18303 жыл бұрын
hey Ruth, would you like get married with an italian Data scientist? :)