Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
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
LOAD
// ID,
// VERSION, EXTERNALIDENTIFIER,
if(len(EXTERNALIDENTIFIER>=7),EXTERNALIDENTIFIER) as Article,
// HOSTIDENTIFIER,
// DESCRIPTION,
// DELETEDBYHOST,
// LASTORDER,
// SHELFLIFE,
best regards
Bjarne
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
where len(EXTERNALIDENTIFIER)>=7;
SQL SELECT *
FROM MSMATERIAL;
Hi Bjarne,
just use a Where Clause:
where len(EXTERNALIDENTIFIER)>=7
- Ralf
Hi Ralf
I have tried this
LOAD // ID,
// VERSION, EXTERNALIDENTIFIER as Article,,
"MERCHANDISECATEGORY_ID" as ArticleGroupID;
SQL SELECT *
FROM MSMATERIAL
where len(EXTERNALIDENTIFIER)>=7;
But it will not "eat" where len(EXTERNALIDENTIFIER)>=7; Any further help?
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
where len(EXTERNALIDENTIFIER)>=7;
SQL SELECT *
FROM MSMATERIAL;
Hi
Length did work. thanks