If Else Question

dmohanty — Thu, 04 Feb 2021 18:12:17 GMT

Hello Experts,

I have a common table, which is formed by Concatenation of two Load Scripts.

Price:

Load * Inline [

Old Account, Account Name, Price

100, John, $500

200, Mary, $350

300, Alex, $0

400, Harry,$1050

500, King , $700

CONCATENATE

Load * Inline [

New Account, Account Name, Price

1000, John, $450

2000, Mary, $0

3000, Alex, $0

4000, Harry, $1200

5000, King , $700

Criteria:

If there is Price existing in Second Table for New Account - display the New Price (from 2nd table)
If there is no Price ($0 or blank) in Second Table for New Account - display the Old Price (from 1st table)
if the Old Price and New Price are same show any one/New Price (2nd table).

Expected Outcome:

Old Account	New Account	Account Name	Price
100	1000	John	$450
200	2000	Mary	$350
300	3000	Alex	$0
400	4000	Harry	$1,200
500	5000	King	$700

Any help would be appreciated! 🙂

Regards!

Re: If Else Question

rubenmarin — Fri, 05 Feb 2021 07:47:31 GMT

Hi @dmohanty, you can do that with this script:

tmpPrice: Load * Inline [ Old Account, Account Name, OldPrice 100, John, $500 200, Mary, $350 300, Alex, $0 400, Harry,$1050 500, King , $700 ]; Outer Join // Merge in the same row by Account Name Load * Inline [ New Account, Account Name, NewPrice 1000, John, $450 2000, Mary, $0 3000, Alex, $0 4000, Harry, $1200 5000, King , $700 ]; Price: LOAD [Old Account], [New Account], [Account Name], If(not IsNull(NewPrice) and NewPrice<>'$0', NewPrice, OldPrice) as Price Resident tmpPrice; DROP table tmpPrice;

topic If Else Question in QlikView

If Else Question

Re: If Else Question