Flat file with variable columns - Hi, can Celonis PQL process a text file with variable columns (see below) in order to achieve the table outcome attached? Any guidance on a general approach would be appreciated, or even just a Yes/No answer. Thanks!

Question

1) Raw file (scrubbed):Role=MEMBER; LOC=IL;CLMC=C;Role=MEMBER; LOC=IL;CLMC=C;Role=MEMBER; LOC=IL;CLMC=C;LOC=IL; CLMC=C;LOC=IL; CLMC=C;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;LOB=LOB1; LOC=IL;CLMC=C;CLR=Y;LGLSST=ASGN;ID=1234,TYPE=PROP;ID=1234,TYPE=PROP;LOC=IL;CLMC=C;LOC=IL;CLMC=C; 2) Desired outcome:

blenda.gashi11 · Answer

Hi Alejandra,thank you for reaching out.Is your question about if Celonis supports flat files? If yes, then yes, you can upload a flat file in Celonis EMS.Some notes:the file upload will trim the string fields to 80 characters automatically,while uploading you need to define a separatorIf you need further support from us, please let us know.Best Regards,Blenda

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded