Qlik Community

Qlik Sense App Development

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

volakakis
New Contributor

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

Re: Conditional load

Load * From

FileName

Where Len(ID) = 7;

2 Replies
MVP
MVP

Re: Conditional load

Load * From

FileName

Where Len(ID) = 7;

volakakis
New Contributor

Re: Conditional load

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

Community Browser