Critical issue with categories done with "if then else"

[Former Member]

Hello all,

I have a critical issue managing categories with thousands of data.

The aim is do group data thanks to several parameters coming from different columns.

The grouping is done in several ways and priorities:

The first group is done thanks to a column A  (ex: if(Length({Trucks}>0 then "Truck")

The second group is done thanks to a column B  (ex: if(Length({Planes}>0 then "Plane")

The 10 other groups are done thanks to different values from  columns C and D (ex: if(Contain({Vehicle},"Turbo") then "Sport car" else if (Contain({Vehicle},"2 wheels") then "Motorcycle" else if({Price}>50 000) then "Luxurious Vehicle" ...

It is crucial to respect the order.

Result:

Lumira only takes into account the first group and don't take into account the other ones.

This is not a coding issue, because the third case works very well with the very same structure (if x1 then y1 else if x2 then y2 else if...).

It might be due to a memory overload.

Do you have any solution for this issue?

Many thanks in advance,

Nicolas

[Former Member · Accepted solution]

Yes Maaz, here is an example:

Article	Description	Trucks	Planes	Price	Result
A000001	4 tons	Truck		25000	Truck
A000002	Bombardier S8		Plane	2250200	Plane
A000003	Turbo truck	Truck		100000	Truck
A000004	Ferrari turbo				Sport car
A000005	Bombardier S8		Plane	2250200	Plane
A000006	Mercedes SLX turbo				Sport car
A000007	Rolls Royce Phantom			150000	Luxurious Vehicle
A000008	2 wheels Harley			65000	Motorcycle
A000009	6 tons	Truck		55000	Truck
A000010	Flying truck	Truck	Plane	250000	Truck

[Former Member · Accepted solution]

I don't know why we can't see the last column result: here it is..

Result

Truck

Plane

Truck

Sport car

Plane

Sport car

Luxurious Vehicle

Motorcycle

Truck

Truck

[former_member198672 · Accepted solution]

Hi Nicolas,

I presume that the "Result" column is what you're trying to achieve, but are unable to. I believe the solution to your problem lies in the handling of null entries. The empty cells basically have a null value assigned to them. I was able to get the formula to consider all the conditions by doing a null check before actually doing any string operation.

So, I think you need to do something on the lines of

IsNotNull({Trucks}) and <some operation with Trucks>

for every column that you expect to have a null entry somewhere in the column.

Did that provide a solution to your problem?

Regards,

Maaz

[Former Member · Accepted solution]

Hi Maaz,

Thanks a lot : it works.

Do you have a tutorial or a book about this kind of practice?

I've bought a book about SAP essentials, but there no information like this.

Regards,

Nicolas

[former_member198672 · Accepted solution]

Hi Nicolas,

Glad it helped! The official tutorials are here .

But, what I explained to you was just out of intuition as I thought that a null object might not be implicitly converted to an empty string.

Regards,

Maaz

[former_member198672]

Hi Nicolas,

Just to clear my understanding, could you share a sample dummy piece of your dataset and a sample of what you are trying to achieve with these calculated dimensions?

Regards,

Maaz