Thanks for posting this video. I really liked the way you explained concatenation basics using & operator and then went on to explain the power of Text.Combine with Text.From and Date.ToText functions. You also mentioned how user interface builds the formula for you if you use Merge Columns which is what I would typically do most of the times. But it probably won't accomplish what you demonstrated in the last example using specific string format for long date. I really look forward to seeing such amazing content from you in your future videos.
I'm glad you liked the build up. There's so many ways to concatenate. As long as you are aware of the risks combining certain values have, you're good to go. So you can make a well weighted decision on the method to use. The most common error I see? Not accounting for 'null' values. But as the video shows, functions like Text.Combine can help there. Cheers Saurabh!
Is there a way to get combiner functions to ignore nulls , so for example Table.AddColumn(#"Added Custom", "Custom.1", each Combiner.CombineTextByEachDelimiter( {"-","/","|"} , QuoteStyle.Csv)( { [A], [B] , [Custom] } )) it does ignore cells that are 'empty' , might have it's uses but seems annoying.
Perfect! 💚
Raimundo - Can't believe how quick you manage to spot new videos. Thanks for the continued support :)
All this material is great. Thanks for sharing.
Thanks for posting this video. I really liked the way you explained concatenation basics using & operator and then went on to explain the power of Text.Combine with Text.From and Date.ToText functions. You also mentioned how user interface builds the formula for you if you use Merge Columns which is what I would typically do most of the times. But it probably won't accomplish what you demonstrated in the last example using specific string format for long date. I really look forward to seeing such amazing content from you in your future videos.
I'm glad you liked the build up. There's so many ways to concatenate. As long as you are aware of the risks combining certain values have, you're good to go. So you can make a well weighted decision on the method to use.
The most common error I see? Not accounting for 'null' values. But as the video shows, functions like Text.Combine can help there. Cheers Saurabh!
You are awesome !!!
Great tricks to combine data. Thank for sharing
Great ！👍
Great as always
Glad to hear it. And a big thank you for showing up again! ❤
Is the file available so we could follow along?
Is there a way to get combiner functions to ignore nulls , so for example
Table.AddColumn(#"Added Custom", "Custom.1", each Combiner.CombineTextByEachDelimiter( {"-","/","|"} ,
QuoteStyle.Csv)( { [A], [B] , [Custom] } ))
it does ignore cells that are 'empty' , might have it's uses but seems annoying.
Rick,
How to replace null values with List.Median through M Language?