Using a where clause with Inline data loads

[AHM1102]

Hello,

I have an inline data load where I'm bringing only certain fields into an ad-hoc table, but I want to be able to limit the data based on one of the fields.  For instance, I want all data to load if the Company listed is 'ABC Company'.  When I try to do this with a where clause, the load fails. 

[marcus_sommer]

An inline-load could have equally where-clauses like each other data-source, like:

t: load * inline [
f1, f2
1, a
2, b
] where f2 <> 'a';

[Chanty4u]

Hi.try this 

AdhocTable:

LOAD

    Company,

    Product,

    Sales

INLINE [

Company, Product, Sales

ABC Company, Laptop, 1000

XYZ Company, Mobile, 2000

ABC Company, Tablet, 1500

]

WHERE Company = 'ABC Company';