Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Go to Solution.
Load * From
Where Len(ID) = 7;
Thank you very much. quick answer and spot on !!!