Originally posted by: ZhaoJie

I need use WTX to organize data like DB group by. following is sample input,  I need group input data by TYPE, MODEL & SERIAL. Can anybody give hint? 

Originally posted by: paul.brett

I am assuming that in each case, the first three data labels are not always going to be the same?

So for example, for input:

TYPE AAAA MODEL AAAA SERIAL AAAA Component 1
TYPE AAAA MODEL AAAA SERIAL BBBB Component 2
TYPE BBBB MODEL BBBB SERIAL BBBB Component 3
TYPE BBBB MODEL DDDD SERIAL BBBB Component 4
TYPE BBBB MODEL DDDD SERIAL BBBB Component 5
TYPE CCCC MODEL CCCC SERIAL CCCC Component 6
TYPE CCCC MODEL CCCC SERIAL CCCC Component 7
TYPE CCCC MODEL CCCC SERIAL EEEE Component 8

...you might get output:

TYPE AAAA MODEL AAAA SERIAL AAAA {Component 1}
TYPE AAAA MODEL AAAA SERIAL BBBB {Component 2}
TYPE BBBB MODEL BBBB SERIAL BBBB {Component 3}
TYPE BBBB MODEL DDDD SERIAL BBBB {Component 4, Component 5}
TYPE CCCC MODEL CCCC SERIAL CCCC {Component 6, Component 7}
TYPE CCCC MODEL CCCC SERIAL EEEE {Component 8}

Anyway, the enclosed map will work with either of these two input files, producing the outputs shown.

Thanks.

Paul.

Follow me on Twitter     <--- go on, you know you really want to!

Attachment(s)

Grouping.zip   3 KB 1 version

Originally posted by: 46S9_xiaowei_li

Hi Paul,

The same TYPE, MODEL, SERIAL records may not be in sequence. Such as below example, the Component 1 and Component 9. How to handle such case? Please advise, Thank you.

TYPE AAAA MODEL AAAA SERIAL AAAA Component 1
TYPE AAAA MODEL AAAA SERIAL BBBB Component 2
TYPE BBBB MODEL BBBB SERIAL BBBB Component 3
TYPE BBBB MODEL DDDD SERIAL BBBB Component 4
TYPE BBBB MODEL DDDD SERIAL BBBB Component 5
TYPE CCCC MODEL CCCC SERIAL CCCC Component 6
TYPE CCCC MODEL CCCC SERIAL CCCC Component 7
TYPE CCCC MODEL CCCC SERIAL EEEE Component 8

TYPE AAAA MODEL AAAA SERIAL AAAA Component 9

Output expected is :

TYPE AAAA MODEL AAAA SERIAL AAAA {Component 1, Component 9}
TYPE AAAA MODEL AAAA SERIAL BBBB {Component 2}
TYPE BBBB MODEL BBBB SERIAL BBBB {Component 3}
TYPE BBBB MODEL DDDD SERIAL BBBB {Component 4, Component 5}
TYPE CCCC MODEL CCCC SERIAL CCCC {Component 6, Component 7}
TYPE CCCC MODEL CCCC SERIAL EEEE {Component 8}

Originally posted by: paul.brett

It becomes a 2 step process.  Sort it first.

Thank-you.

Paul.

Follow me on Twitter     <--- go on, you know you really want to!

Attachment(s)

Grouping2.zip   5 KB 1 version

Originally posted by: 46S9_xiaowei_li

Thanks paul, it is very helpful.