Eliminate particular value in script

[stephenedberkg]

i have the account number like 1,2,,3,4,5,6,7,8,9 and its sales values

i want to eliminate the account number 1st and its sales in script level (Edit script) only.

[settu_periasamy]

Hi,

Try Like

Load Your Fields,

From

Source

where AccountNumber <>1;

[Anonymous]

Hi,

but the account number is Always 1?

Or do you want do discard the first record?

Order you the record per Account Number?

[sunny_talwar]

In addition if you have other tables which have are explicitly or implicitly joining to your fact table, you can use Left Join or Left Keep, respectively to remove any rows of data which corresponds to account number 1.

[Kushal_Chawda]

try,

Load *

From Table

where not wildmatch(AccountNumber ,'1*');

[#6]

Hi,

Try this,

Load FeildName

from TableName

WHERE not match(FeildName,'1');

Best Regards,

Bhavesh

[miguelbraga]

Hi Stephen,

You can do it by creating a variable in script in which you can define what is your Acount Number you wish to eliminate. In your case the account number is 1. You can also change this variable by using a input box in your dashboard.

Set vAccount = 1;

[Your Table]

LOAD *,

FROM ("Source Goes here")

WHERE [account number] <> $(vAccount);

Hope it helped you . Have a great weekend.

Regards,

MB

[jagan]

Hi,

If you want to eliminate account number simply you can use where condition to filter those records like below

Data:

Load *

From DataSource

WHERE AccountNumber <>1;

Hope this helps you.

Regards,

jagan.

[ashwanin]

Hi Stephen,

Simple way to remove a specific account from a number of a/c numbers is :

Load

AccountNumber,

Sales

from abc*xls Where AccountNumber <> '1' ;

[maxgro]

if you have a dimension table with your account you can first load that table

Dim:

load

     AccountNum,

     AccountDesc,

     .......

from ....

     where .... <> 1;

and then load your fact (sales) table 

Sales:

load

     ....

from

     ......

where Exists(AccountNum);