Skip to main content
Question

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!

  • June 29, 2022
  • 1 reply
  • 2 views
A
Level 0
Forum|alt.badge.img+6

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:

desired_outcome_scrubbed

1 reply

B
Level 0
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 separator If you need further support from us, please let us know. Best Regards, Blenda
Community Code of ConductAccessibility statement