Adding the data from excel files.

S1m55r — Sat, 16 Nov 2024 19:18:38 GMT

Hello,

Why Qlik team is not adding more filter condition while adding the data from excel files.

For QS Nov 2018 version i'm getting below conditions. these options are great but would be cool if we have more options like below data connector filters.

is there any other to do this besides data load editor.? I'm not familiar with data load editor

Filtering data from data connector

BETWEEN

IS NULL

IS NOT NULL

Re: Adding the data from excel files.

jupitopino — Tue, 14 Jan 2020 11:10:13 GMT

Hi.

You can do all these options and many more from the load editor, with functions for example...
Strimg functions: https://help.qlik.com/en-us/sense/1.1/Subsystems/Hub/Content/Scripting/StringFunctions/StringFunctions.htm#
logical functions: https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/LogicalFunctions/LogicalFunctions.htm
Condtional functions: https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/ConditionalFunctions/ConditionalFunctions.htm
You only just need put the required condition ("where" Condition) in the load section in the script.
Regards.

topic Re: Adding the data from excel files. in App Development

Adding the data from excel files.

Re: Adding the data from excel files.