Solution Needed in Expression...

[#1]

Hello Everyone,

I have one column, 'Cause Code'. The few values of 'Cause Code' should be grouped together.

  'Data Entry Issue', 'File Missing/Deleted', 'Data Exception' ,'Data Invalid Missing' should be grouped as 'Data Issue'.

The summed values should be shown against 'Data Issue'.

Can you please suggest me? Appreciate your valued suggestions.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

One option is using an if statement:

LOAD

     ...some fields...,

     if(match([Cause Code], 'Data Entry Issue', 'File Missing/Deleted', 'Data Exception' ,'Data Invalid Missing'), 'Data Issue' , [Cause Code]) as [Cause Code],

     ...some more fields...

FROM ....

Instead of arranging this in the script (as you should) you can also use the if statement as a calculated dimension.