Performance Improvement

arusiva89 — Thu, 09 Apr 2020 12:59:23 GMT

Hi Everyone,

I have a question regarding the performance.My code is like

Load A as A

B as B

Resident table where x=1

Concentate

Load A as A1

B as B1

Resident table where x=2

Code is working fine but I am not sure whether it impacts the performance.Let me know if there is any better way to achieve this

Re: Performance Improvement

Claudiu_Anghelescu — Thu, 09 Apr 2020 16:13:14 GMT

You can check the following in order to see which is more quick:

Load

if(Match(x,1),A) as A,

if(Match(x,1),B) as B,

if(Match(x,2),A) as A1,

if(Match(x,2),B) as B1

Resident table where Match(x,1,2)