AnsweredAssumed Answered

Suggestion for a process XML to DB with grouping and deleting data

Question asked by cjitpongumpai917281 on Aug 28, 2018
Latest reply on Aug 28, 2018 by cjitpongumpai917281

Hi there, 

I am planing to built a process which contains multiple record in XML file. 

Example:

ID             Date 

A1123      120118

D1236      140217

R5214      090918

E1112       NA

A1123      120116

R5214      111117

E1112       060418

D1836      NA

 

First I want to group them, if they are the same ID group them together, like this:

 

ID             Date

A1123      120118

 

A1123      120116

 

D1236      140217

 

R5214      090918

R5214      111117

 

E1112       NA

E1112       060418

 

D1836      NA

 

If the ID which is a single record or a group ID but no NA in the date field, they will be transferred to be a Database file.

But if there is NA in the group, delete that row and then change to be a Database file 

 

ID             Date

A1123      120118

 

A1123      120116

 

D1236      140217

 

R5214      090918

R5214      111117

 

E1112       NA

E1112       060418

 

D1836      NA

 

The final result could be like this:

 

ID             Date

A1123      120118

 

A1123      120116

 

D1236      140217

 

R5214      090918

R5214      111117

 

E1112       060418

 

D1836      NA

 

Can anyone give me some ideas to build the process please?

I really have no idea to start this.

 

Best regards,

Chaya

Outcomes