Adding a timestamp to data rows in a CSV file that is sent out via an Action Flow

Question

Hello everyone!I want to send an Action Flow weekly that displays the material numbers that qualify for an automatic ordering process (this process can be triggered by editing the material master data). Since employees might choose not to edit the master data due to various reasons, the one material number for example will show up every week in the CSV that is sent via the AF. It could be possible that this repetitive sending of material numbers that should not be automatically ordered might negatively affect the acceptance of the AF. Here's my idea: does somebody have an idea how to add a timestamp of the initial sendout of the data rows in the CSV file? So, for example, if one material number was already sent out via the AF on the 1st of January, in the next runs of the Action Flow the 1st of January will be visible in an extra column, so employees could filter it easily to the current date.  Thank you so much! BRJulia Bauer

matt.witty13 · Accepted Answer

The main way around this is to write back your action flow run to Celonis. By writing it back, you're establishing a sort of change log.

You'd then have to join the change log to the data model to the table you're referencing so you can do either a) a filter on materials which already exist in the change log or b) the timestamp of the most recent appearance of the material in an action flow.

This page will show you how to do that - https://docs.celonis.com/en/push-csv-to-data-integration.html

mukesh.gupta11 · Answer

The main way around this is to write back your action flow run to Celonis. By writing it back, you're establishing a sort of change log.

You'd then have to join the change log to the data model to the table you're referencing so you can do either a) a filter on materials which already exist in the change log or b) the timestamp of the most recent appearance of the material in an action flow.

This page will show you how to do that - https://docs.celonis.com/en/push-csv-to-data-integration.html

if you don't want to add additional table in DM, just perform the join with DM material table with the table pushed by action flow and bring the date column into DM material table.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN