topic Re: A Where LOAD with a pick Match in App Development

A Where LOAD with a pick Match

nathan_roadshow — Tue, 30 Nov 2021 16:25:32 GMT

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)

tresB — Wed, 24 Nov 2021 06:29:00 GMT

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

MarcoWedel — Wed, 24 Nov 2021 21:27:39 GMT

maybe

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