Thursday, March 7, 2013

How to handle single quotes in Inline Load


You can enclose field names in [ ], ` `, ´ ´ and " " pairs. So try it like this:

LOAD * INLINE [
    F1, F2
    Actuals, sum({$<"Source Name" = {'Current View'}>}"Outlook Units")
];

Or if you have no double quotes in your expressions try:

LOAD * INLINE "
    F1, F2
    Actuals, sum({$<[Source Name] = {'Current View'}>}[Outlook Units])
";

No comments:

Post a Comment