Skip to main content
Question

Hello, After I query the data, I need to create a CSV file in a certain order in Action Flow. I only need 3 columns with the following order: Group Id, User Id, User Action. However, no matter what I do, it changes the column order.

  • January 26, 2023
  • 5 replies
  • 11 views

and always start with User ID. How can I fix it? When I use advanced CSV, it doesnt allow me to name the column. it automatically name as Column1 name, Column2 name etc.

Thanks

5 replies

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

Hi Mustafa,

 

Can you share a screenshot of your CSV module ?

 

How have you created the Data structure for the same ?


  • Author
  • Level 3
  • January 27, 2023

Hi Abhishek,

 

You can see the screenshot of CSV attached. No, I have not created a data structure, I think it is is the answer I am looking for. Can you please tell me how to create a data structure? Thanks


Forum|alt.badge.img+11

Hi Mustafa,

Did you try to set the "Column Sorting" in the Celonis Query Data module?

image


  • Author
  • Level 3
  • January 30, 2023

Hello Marcel,

 

I think what you are referring is to sort the data inside of the columns. However, I am trying to order the columns.

 

I took care of the problem creating a new data Structure. I share the solution with others who may encounter the similar problem.

 

Method:

Add Module(Create CSV Advanced) --> Add data Structure --> Give a name (udts.name) --> Click "Generate"-->Choose JSON -->Use the following code: Replace the desired Column names with the column names below.

{

"Column 1 Name": "",

"Column 2 Name": "",

"Column 3 Name": ""

}

 

 


Forum|alt.badge.img+11

Hello Marcel,

 

I think what you are referring is to sort the data inside of the columns. However, I am trying to order the columns.

 

I took care of the problem creating a new data Structure. I share the solution with others who may encounter the similar problem.

 

Method:

Add Module(Create CSV Advanced) --> Add data Structure --> Give a name (udts.name) --> Click "Generate"-->Choose JSON -->Use the following code: Replace the desired Column names with the column names below.

{

"Column 1 Name": "",

"Column 2 Name": "",

"Column 3 Name": ""

}

 

 

Hi Mustafa,

Yes, I was referring to sorting the data within the column.

Glad you found a solution!

Best,

Marcel