Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
volakakis
Contributor II
Contributor II

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

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';

View solution in original post

4 Replies
sunny_talwar

May be like this:

LOAD *

FROM ...

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

Nicole-Smith

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
MVP
MVP

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
Contributor II
Contributor II
Author

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