how to form a target in descending order for predictive maintenance

[Danielht]

Hello community,
I want to form a descending 'New_target' where 0 represents the failure of a machine (In Fault or Target). I show a table (the real data I will put it in excel to download). Any ideas?

Target	Date	Hours	Fault	S1	New_target
0	20/01/2018	8	0	6	0
1	20/01/2018	12		2	5
2	20/01/2018	13		7	4
3	20/01/2018	16		9	3
4	20/01/2018	18		3	2
5	20/01/2018	19		9	1
0	20/01/2018	22	0	5	0
1	20/01/2018	23		3	3
2	21/01/2018	0		8	2
3	21/01/2018	1		7	1
0	21/01/2018	12	0	7	0
1	21/01/2018	21		5	4
2	22/01/2018	1		2	3
3	22/01/2018	2		1	2
4	22/01/2018	23		2	1
0	22/01/2018	24	0	1	0

[AbhilashR]

Hello @Danielht, would something like the attached solution work for you? Below are the broad steps I took:

1. Included a RecordID tool to number the individual rows in your dataset
2. Artificially grouped the data using multi-row formula tool
3. Filtered out rows with target = 0
   
   1. using a combination of Summarize and Append tool, I re-number the RecordID for the filtered target = 0 rows
4. All non-zero target rows get passed to the output
5. Union all and finally apply a sort

Let us know if I misunderstood your ask, or if you need clarification on any specifics I used.

[Danielht]

Hi @AbhilashR 
Thank you very much for responding, but I would like Date and Hours to be ordered in ascending order. Only New_Target should be in descending form.

Can be done?

[AbhilashR · Accepted solution]

Hi @Danielht, thanks for getting back to me! I have modified solution to keep all columns as-is, but just reverse the number of target column. 

Let us know if this works. 

[Danielht]

Thank you very much friend @AbhilashR , greetings from Lima Peru.