Match Column Data and get Value

[#1]

A	B
1	100
2	99
3	98
100	1
101	0

I have this table.

I want to set B value ,If my value equals A .

For example ;

C = 1        =>   100

C=100      =>    1  

in my pivot table.

Have nice a day.

[jyothish8807]

Hi Murat,

Try doing mapping load.

tab1:

mapping load

A,

B

resident.

In your table:

load *,

applymap('tab1',sum(Quantity)) as B

resident <>.

Then use this field.

Regards

KC

[sunny_talwar · Accepted solution]

This?

Expression: =If(Sum(Quantity) > 120, 0, Only(Aggr(If(A = Sum(Quantity), B), CustomerID, A, B)))

Update: Although the solution is working, I don't recommend this as this Aggr() function can take a lot of your system resources for a bigger data set. The same can be done in script which might take some time to run in the script, but will not affect your front end.

[#4]

Thank you so much  Sunny

dimesion : Grup

first exp: Vade =>   Sum({<Rapor={"Satış"},VadeHesapla={"1"}>}VadeEurPuan) / Sum({<Rapor={"Satış"},VadeHesapla={"1"}>}Eur)

second exp:  If("Vade" > 120, 0, Only(Aggr(If(A = "Vade", B), Grup, A, B)))

I try this but not work only works    "Vade" > 120, 0,

Why not workıng this part     Only(Aggr(If(A = "Vade", B), Grup, A, B)))

[#5]

I want to set in expression.

Thank you so much for your interest

[sunny_talwar]

I don't think expression name will work here, you will have to use the whole expression within Aggr:

If("Vade" > 120, 0, Only(Aggr(If(A = Sum({<Rapor={"Satış"},VadeHesapla={"1"}>}VadeEurPuan) / Sum({<Rapor={"Satış"},VadeHesapla={"1"}>}Eur), B), Grup, A, B)))

[#7]

Thank you Sunny. My problem is extension of number. I used ceil and fixed.

[sunny_talwar]

Not sure I understand, what do you mean by extension?

[#9]

I am sorry , I mean my number was float so I changed integer and it works.

[sunny_talwar]

So all is working now?

[#11]

Yes, All  works now.