Performance Improvement

[arusiva89]

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

[Claudiu_Anghelescu · Accepted solution]

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)