A Where LOAD with a pick Match

[nathan_roadshow]

Hi all, 

I am looking to do the below:

I want to load a table, but have it so that it changes certain information due to outliers.

For example, I would like to Load *, but where IP DESC='Bread', have its associated Platform='Food' rather then 'Carb', which it currently equals. 

What's the best way to do this?

Material_MasterTable_Final:
LOAD
IP,
"IP Desc",
Platform,
Platform_Type

FROM [FILE LOCATION]
(qvd)

[tresesco]

It seems to be a AND condition in where clause, but not sure. Could you explain with an example?

[MarcoWedel]

maybe

Material_MasterTable_Final:
LOAD IP,
     [IP Desc],
     If([IP Desc]='Bread','Food',Platform) as Platform,
     Platform_Type
FROM [FILE LOCATION] (qvd);