topic Calculate different logic based on predefined logic in a field in App Development

Calculate different logic based on predefined logic in a field

Carol_Wu_ — Sat, 16 Nov 2024 00:33:45 GMT

Hi Expert,

I have a question that want to seek an answer.

I have a field D in which I saved different logics based on field A, field B or field C.

Then I need to calculate D in the scripts, because my real data have many many different logics.

So the output from the scripts should be:

May I know if you have any ideas on how to realize it, thanks!

Re: Calculate different logic based on predefined logic in a field

Anil_Babu_Samineni — Sun, 21 Feb 2021 18:52:32 GMT

What is the logic behind for D column from row level?

Re: Calculate different logic based on predefined logic in a field

Saravanan_Desingh — Mon, 22 Feb 2021 00:37:33 GMT

Try this,

tab1: LOAD RowNo() As ID,* INLINE [ A, B, C, Exp_D 1, 2, 0.95, A*B*C 1000, 20, 1, A*C 1, 100, 2, B*C ];

Expression 😧 Pick(ID,A*B*C,A*C,B*C)

Re: Calculate different logic based on predefined logic in a field

Saravanan_Desingh — Mon, 22 Feb 2021 00:38:09 GMT

Ouput:

Re: Calculate different logic based on predefined logic in a field

Carol_Wu_ — Wed, 24 Feb 2021 10:34:26 GMT

Hi Saran,

This method is ok for this file, but for my real data, there are around 100K row with around hundred logics in different rows.

So i think i can't write pick function for it.

Re: Calculate different logic based on predefined logic in a field

Carol_Wu_ — Wed, 24 Feb 2021 10:38:38 GMT

The D column is defined by user to calculate the rate value based on different conditions.

So I have hundred logics in different rows of data like below. I have the field sales_selling_price, total_gold_value and org_labour_cost. So i need to based on the expression to calculate the logic out.

Re: Calculate different logic based on predefined logic in a field

Carol_Wu_ — Thu, 25 Feb 2021 01:58:39 GMT

I have solved my question already by using the loop function. thanks

Re: Calculate different logic based on predefined logic in a field

Saravanan_Desingh — Thu, 25 Feb 2021 03:40:06 GMT

Try this. If you think its faster than your code, you can use it.

tab1: LOAD RowNo() As ID,* INLINE [ A, B, C, Exp_D 1, 2, 0.95, A*B*C 1000, 20, 1, A*C 1, 100, 2, B*C ]; tab2: LOAD Concat(Exp_D,',',ID) As StrPick Resident tab1; Let vPick=Peek('StrPick'); tab3: LOAD ID, A, B, C, Pick(ID,$(vPick)) As D Resident tab1; Drop Table tab1, tab2;