I have done full outer join on all three excel data sources with keys on calculated field of CR#(Split(CR#, ',' ,1)
Then create a calculated field for CR as below.
if len([CR1]) > len([CR2])
then if len([CR1]) > len ([CR3])
ELSEIF len([CR2]) > len ([CR3])
You will then get the desired result.
Attaching the workbook also for reference.
Match Column.twbx 23.1 KB
Thank you so much, this is what I was expecting.
Is there a way to hide null values? I have a text table, more than 20 columns, more than 10k records, mostly which is null, how do I hide those things? Should i create 20 calculated fields to call the dimension into it and use iffnull command?
Also When using ifnull command on Date type (21-11-2018)
the result is 2018/11/21
I was to use the same already existing format, don't understand why the format was changed when using it as string!!!
Thanks in advance.
Please follow the below links for replacing nulls.
For Replacing nulls of Dimension.
Follow option 1.
For Replacing nulls of Measure.
For Replacing nulls in date keeping the format.