Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo,
i have a Problem with my Load-Script
All i've tried ends with an Invalid Expression Error:(
I have a table similar to this example:
DataTable:
Product_id | Seq_id | Phase
2 1 clean
2 2 produce <--------------------*1
2 3 produce
2 4 use
2 5 clean
3 6 clean
3 7 produce <--------------------*1
3 8 produce
3 9 use
3 10 clean
4 11 clean
4 12 produce <--------------------*1
4 13 produce
4 14 use
4 15 clean
And i want to get the Rows marked with *1.
I tried:
1.
Produce:
Load Product_id,Min(Seq_id ) as MinSeq resident DataTable where Phase='produce';
2.
Produce:
Load Product_id,Seq_id resident DataTable where Phase='produce'; (is correct)
ProduceID:
Load Product_id,Min(Seq_id ) as MinSeq resident Produce;
What i am doing wrong?
Pls help me:)
Sry i can only mark one of u as correct answer and swuehl wasd the faster one;)
But thanks to both for the fast reply!
Try
Produce:
Load Product_id,Min(Seq_id ) as MinSeq resident DataTable where Phase='produce' group by Product_id;
Try
Produce:
Load Product_id,Min(Seq_id ) as MinSeq resident DataTable where Phase='produce' group by Product_id;
You have to calculate min value with where condition but dont write the condition that on what basis you calculte this
so its minor mistake use group by function then it works like a charm
like this
Load Product_id,Min(Seq_id ) as MinSeq resident Produce
group by Product_id;
or with where condition
Load Product_id,Min(Seq_id ) as MinSeq resident DataTable where Phase='produce'
group by Product_id;