nevilledhamsiri
Specialist
2017-08-12
01:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
reply on answer
Applied the said formula, but an error comes in loading the data, Look forward to resolve this!
LOAD CLASS_CODE,
Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR',
PREMIUM
FROM
D:\CLASS.xlsx
(ooxml, embedded labels, table is Sheet1);
339 Views
1 Solution
Accepted Solutions
felipedl
Partner - Specialist III
2017-08-14
02:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Neville,
You're missing a parenthesis on the Pick statement
Like this
LOAD CLASS_CODE,
Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR') as T,
PREMIUM
FROM
D:\CLASS.xlsx
(ooxml, embedded labels, table is Plan2);
272 Views
1 Reply
felipedl
Partner - Specialist III
2017-08-14
02:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Neville,
You're missing a parenthesis on the Pick statement
Like this
LOAD CLASS_CODE,
Pick(Match(CLASS_CODE,'MC','M3','M4')+1,'NONMOTOR','MOTOR','MOTOR','MOTOR') as T,
PREMIUM
FROM
D:\CLASS.xlsx
(ooxml, embedded labels, table is Plan2);
273 Views