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 . (
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
Go to Solution.
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:
WHERE NOT Field LIKE '????0000';
May be like this:
Where WildMatch([Column A], '*0000') = 0;
another one could be
load * inline [
where not line like '*0000'
Thank you all guys. I am overwhelmed from your quick and accurate responses