Load data only if a criteria is met

[#1]

I am trying to do the following :

load accounts that have a  type "Headquarters"  as Parent Account. I want to do this when data is loaded.

Note data is coming from salesforce.

Is this possible to do in the edit script?

[thomas_skariah]

Hi Victor,

The application must reload only when account type is 'headquarters'?

Otherwise no need to reload.Is it right.

Regards,

Tom

[#3]

Almost.  The account will always reload. What i would like to happen is that when it loads the Accounts, to take all the accounts that have an account type of "Headquarters" to load in a dimension called Parent Account.

Hope I explained it.

[thomas_skariah]

Hi Victor,

Sorry if i didn't got your point.

You can do the following the code in your edit script.

Load Parent Account

from test.xls

where account_type='Headquarters';

Regards,

Tom

[#5]

Thank you Tom for the info. What if I am bringing the data in from SalesForce? Will the code be the same?