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

Conditional load

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 (either 2 digits or 7 digits).

Is there a way to load only the rows that have got 7 digits?????? (or to ignore the lines with 2digit ID)

Thank you in advance and wishing you a happy new year

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Load * From

FileName

Where Len(ID) = 7;

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Load * From

FileName

Where Len(ID) = 7;

volakakis
Contributor II
Contributor II
Author

Thank you very much. quick answer and spot on !!!