Can Pick(Match using in load script ?

[paulyeo11]

I get error on this script :- Sum([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales_n,

Hi All

I have below scipt from expression it work fine :-

Sum(total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

I have convert it to become load script :-

Sum([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales_n,

May i know where go wrong on above above script ?

Paul Yeo

[Vegar]

You are not showing us the whole loaded statement, but I would guess be that you are aggregating in a load statement without a GROUP BY.

Load

Sum([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales_n,

Dim1,

Dim2

From  source

Group by Dim1, Dim2;

Or you might want to skip the aggregation like this.

Load

[Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1) as sales_n,

Dim1,

Dim2

From  source;

[paulyeo11 · Accepted solution]

Hi Sir

Thank you for your advise.

Some one have already advise me , my issue is I need to remove the sum to make it work.

Paul