topic Why can't I use applymap on a CSV load? in QlikView

Why can't I use applymap on a CSV load?

qlikmark1990 — Tue, 20 Feb 2018 09:30:21 GMT

I have an applymap function in my QLikView application that loads a CSV file. Before it was an Exel file and the function worked correctly. Now I converted my Excel files to CSV files and run into an error. My code is:

MapAanpassingen_data_NAW:

Mapping LOAD [waarde-in] as [waarde-in1], [waarde-uit] as [waarde-uit1]

FROM [Aanpassingen data alle tabellen.xlsx] (ooxml, embedded labels, table is Blad1)

Where (sheet <> 'NAV' and actie <> 'delete');

NAW1:

LOAD

applymap('MapAanpassingen_data_NAW', zoeknaam, zoeknaam) as zoeknaam,

geslacht, H_PC, geboortedatum, land

FROM [171220 NAW.csv] (txt, utf8, embedded labels, delimiter is ';', msq)

Where len(applymap('MapAanpassingen_data_NAW', zoeknaam, null())) >= 1;

The error that I recieve is :

File format error

Unsupported or bad format in BIFF file

Things that I tried:

Using the 171220 NAW.xls file with exactly the same data and field names > succesfullly
Create a table with the content of the file

Test:

LOAD zoeknaam, geslacht, H_PC, geboortedatum, land

FROM [171220 NAW.csv] (txt, utf8, embedded labels, delimiter is ';', msq); > succesfully

Whats the reason of this error and how to solve this?

Re: Why can't I use applymap on a CSV load?

Peter_Cammaert — Tue, 20 Feb 2018 11:22:09 GMT

It seems that somewhere in your code, someone is still trying to read an old-style XLS file (BIFF). Are you sure all option strings have been modified when switching from Excel format to CSV format? Maybe you are creating another Mapping table where you changed the source file name, but forgot to change the option string?

Re: Why can't I use applymap on a CSV load?

qlikmark1990 — Tue, 20 Feb 2018 12:16:37 GMT

Thanks you for your reply. Indeed, somewhere else in my script I was still trying to read an XLS file instead of CSV file.