Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
volakakis
Not applicable

condiational load script

Hi guys

I have a problem. I have to load an weird excel file in which the column A has got some unique ID codes . (

A1040000
01040100
01040200
01040300
01040400
01040500
01050000
B1050100
01050200
01050300
01050400

01050500)

And I DONT want to LOAD the lines which are ****0000, only the others

Thank you in advance and wishing you a happy new year

1 Solution

Accepted Solutions
Nicole-Smith
Not applicable

Re: condiational load script

Another option...

LOAD *

FROM YourFile

WHERE NOT Field LIKE '*0000';

If you want to make sure there can only be four values before the 0000, then you want to do it this way:

LOAD *

FROM YourFile

WHERE NOT Field LIKE '????0000';

4 Replies
sunny_talwar
Not applicable

Re: condiational load script

May be like this:

LOAD *

FROM ...

Where WildMatch([Column A], '*0000') = 0;

Nicole-Smith
Not applicable

Re: condiational load script

Another option...

LOAD *

FROM YourFile

WHERE NOT Field LIKE '*0000';

If you want to make sure there can only be four values before the 0000, then you want to do it this way:

LOAD *

FROM YourFile

WHERE NOT Field LIKE '????0000';

maxgro
Not applicable

Re: condiational load script

another one could be

z:

load * inline [

line

A1040000

01040100

01040200

01040300

01040400

01040500

01050000

B1050100

01050200

01050300

01050400

01050500)

]

where not line like '*0000'

;

volakakis
Not applicable

Re: condiational load script

Thank you all guys. I am overwhelmed from your quick and accurate responses