LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dhrobertson

Hi there,

I'm not sure if there is any easy way of doing this, but my client has asked whether it is possible to use an excel spreadsheet to define certain fields to be used to populate other fields based on a criteria...

what I'm getting at is this:

I need to output in the final dataset, 2 fields. 1 called attribute1 the other attribute2. Based on the countrycode, this attribute1 and 2 will be populated from different fields based on country, lets say, GB and FR. I can do this in an IF statement whereby: attribute1 = if (countrycode == "GB") then descriptor1 else descriptor2 etc.etc. But this is hardcoded.

the problem if that the client may want to change the descriptor for any country and would like to just be able to change this field in the spreadsheet which will automatically filter through into the output. they do not want to have to change the graph physically.

I have explained using parameters and that is an option but I may have to create up to 50+ parameters to cater for all scenarios. they would like to just update a speadsheet with new field names and my graph sucks these in and assigns somehow to attribute1 and attribute2.

I personally do not see how this can be done as you have to use parameters if a value is going to change. I don't believe there is a way of them controlling this via a spreadsheet and if they wanted to change the field they would have to change the run parameter in logistics manager of something like that.

I thought I would ask the question and maybe someone has an idea?

thanks

Douglas

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

The attached graph should demonstrate what you are asking for. It uses a Lookup and the FIELD() function to accomplish the task.

What you can not do with this method is change the name of the OUTPUT column.
Attachments:
Select Input Value.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dhrobertson

Thanks Stony, I think that will work nicely. thanks