Where Clause does not work

[MikeGaunt]

Hi All, 

A simple where clause doesnt work 

[Format]:
LOAD
[SO],
[Sales Document Item],
[Material],
[Item Description],
[Item Qty],
[Contract Admin],
[Ship to Name],
[Ship to Account],
[Ship to City],
[Ship To],
[First Date],
[Item Release Status],
[Ship Request No],
[Delivery Note],
APPLYMAP( '__cityKey2GeoPoint', APPLYMAP( '__countryCodeAndCityName2Key', APPLYMAP( '__countryName2IsoThree', LOWER([Ship To])) & LOWER([Ship to City])), '-') AS [Format.Ship to City_GeoInfo],
APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([Ship To])), '-') AS [Format.Ship To_GeoInfo]
FROM [lib://BI/GCO TAB.xlsx]

Where

[Item Release Status] = 'Not Released'

(ooxml, embedded labels, table is Format);

error message reads 

The following error occurred:

Cannot open file: 'lib://BI/GCO TAB.xlsx Where Item Release Status = Not Released' (Native Path: *** System error: ***)

The error occurred here:

[Format]: LOAD [SO], [Sales Document Item], [Material], [Item Description], [Item Qty], [Contract Admin], [Ship to Name], [Ship to Account], [Ship to City], [Ship To], [First Date], [Item Release Status], [Ship Request No], [Delivery Note], APPLYMAP( '__cityKey2GeoPoint', APPLYMAP( '__countryCodeAndCityName2Key', APPLYMAP( '__countryName2IsoThree', LOWER([Ship To])) & LOWER([Ship to City])), '-') AS [Format.Ship to City_GeoInfo], APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([Ship To])), '-') AS [Format.Ship To_GeoInfo] FROM [lib://BI/GCO TAB.xlsx] Where [Item Release Status] = 'Not Released' (ooxml, embedded labels, table is ***)

Any Ideas? Full script attached

[marcus_sommer · Accepted solution]

The where-clause is wrongly placed - in-between the from-statement. It should look more like:

FROM [lib://BI/GCO TAB.xlsx] (ooxml, embedded labels, table is Format)
Where [Item Release Status] = 'Not Released';

- Marcus

[MikeGaunt]

Golden Mate cheers - still learning