Interaction Match Issue

[#1]

Hello Gurus,

Can you please help me this, I've shucked here.

I created one variable like below

eLoadFactor = (Sum ([# Transported Passengers]) / Sum ([# Available Seats]))

Now, I want to create interaction match with the field of "Carrier Name". Please help me

Especially Sunny, Suehl and Gysbert or any thing else.

[sunny_talwar]

Interaction match? Do you mean Interval Match or something else? Would you be able to share a sample to demonstrate what you are trying to do?

[krishnacbe]

Hi,

Please share some sample data and output you are expecting. that will help us to provide the soultion

[Anonymous]

Hi,

Please, add your qvw file or other, so we can see what you want to do.

[Anil_Babu_Samineni]

Deepa Agarwal,

I've read few months back about interaction match. Does it related to Bucket like 0-10, 0-20, 0-30 .....

Can you please elaborate more?

[#6]

Sunny, Might be i am not the good exaplainer. Might be this best way to approach i've tried this

Aggr(If($(eLoadFactor) <20,'0-20',  If($(eLoadFactor) >20 and <40 ,'21-39', If($(eLoadFactor) >=40 and <60,'40-59', >= 59,'59-100',  [Carrier Name])

Anil - you are correct

Krishnapriya & Filip, This is not possible because i am working for secured project. If i released sample data might be stakeholder will frustation on me. I know how to scramble data. In fact, i don't want to take risk. For ref, please follow the above expression

[sunny_talwar]

So you above provided expression worked for you?

[Anonymous]

Hi Deepa,

You Can you Class function to create  Buckets.

class(aggr(eLoadFactor,[Carrier Name]),10,'X')

[rupamjyotidas]

Instead of trying in expression, Create your 'interaction match' or Bucket in the script, in this way you don't complicate your expression and its easy to handle.

[Anil_Babu_Samineni]

Deepa Agarwal,

I've taken Nitin Expression. Try this too

=Aggr(Class($(eLoadFactor),10), [Carrier Name], '<= x <', ' - ')