Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a source file, from this source file I need to create a new table with grouping condition applied.
Grouping Condition is that if records having the same Order list,Airport and Consignee number is found then we should the records in to one.
I have attached the source file and file with expected results.
Would be helpful if this can be done.
Replace the last three dimension in your straight table with measures:
concat([Consignment Number], ',')
concat([Order Number],',')
sum([Total Weight])
Replace the last three dimension in your straight table with measures:
concat([Consignment Number], ',')
concat([Order Number],',')
sum([Total Weight])
Thanks for the feedback, but how to make the comparison as I need to concat the Consignment number only if columns Order List, Airport and Consignee is same between two rows. If this condition is not met then the grouping should not be done.
Thank you for the solution. It works fine🙂