Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

wolfgangmohr
New Contributor II

Change of Script from .xlsx to .txt empty fields

Hi Folks,
for reasons of simplyfication I changed the Import file / script from *.xlsx to *.txt

Now it noticed that *.txt has another Approach to empty fields in the file.

Whereas <Rechnung={"*"}> gives me on Basis *.xlsx only those fields which are not empty,
this formula gives me on Basis *.txt also those which are empty.

The formula <Rechnung={"?*"}> will return only those fields which are not empty in *.txt.

The *.txt fields are also giving me the 'empty value' as selection possibility, which is not the
case in *.xlsx files.

Here the bottom of the script:
FROM
RS Files\RS Startup Auftrag.TXT]
(txt. Codepage is 1252, no Labels, delimiter is '\t', msq);

I labelled it the way that:  @23 as Rechnung

Please assist, thank you so much in advance!

Wolfgang

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Change of Script from .xlsx to .txt empty fields

Hi

From the ref manual:

set NullInterpret=' ';

set NullInterpret =;

will NOT return null values for blank values in Excel (but it will for a csv text file)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: Change of Script from .xlsx to .txt empty fields

Hi

From the ref manual:

set NullInterpret=' ';

set NullInterpret =;

will NOT return null values for blank values in Excel (but it will for a csv text file)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
wolfgangmohr
New Contributor II

Re: Change of Script from .xlsx to .txt empty fields

Hi Jonathan,

I should spend some free time, if any , into the study of this and other Manuals.

Thanks a lot! Your saved my day!

Wolfgang

Community Browser