Discussion Board for collaboration related to QlikView App Development.
I have a small problem. I am loading some data and there I have articles with different number of figures (5-7-8-9). I will only load data for the articles that has a length of 7 of more.
How do I do that?
EXTERNALIDENTIFIER is my article and I have tried some different solutions without luck
// ID,// VERSION, EXTERNALIDENTIFIER, if(len(EXTERNALIDENTIFIER>=7),EXTERNALIDENTIFIER) as Article,
// HOSTIDENTIFIER,// DESCRIPTION,// DELETEDBYHOST,// LASTORDER,// SHELFLIFE,
Go to Solution.
Which database vendor do you have? Could be length( )..
You could also use a where clause in the LOAD part:
LOAD // ID,// VERSION, EXTERNALIDENTIFIER as Article,,
"MERCHANDISECATEGORY_ID" as ArticleGroupID
SQL SELECT *FROM MSMATERIAL;
View solution in original post
just use a Where Clause:
I have tried this
"MERCHANDISECATEGORY_ID" as ArticleGroupID;
SQL SELECT *FROM MSMATERIALwhere len(EXTERNALIDENTIFIER)>=7;
But it will not "eat" where len(EXTERNALIDENTIFIER)>=7; Any further help?
Length did work. thanks