Emmanuel Katto Dubai : How to Handle Constantly Changing Data Sources in Workflows?

[emmanuelkatto24]

Hi everyone,

I am Emmanuel Katto from Dubai, United Arab Emirates (UAE) have a file that changes frequently, with new data added every week and month. Some of the columns change names depending on the month, and occasionally, entire columns are removed. For example, one month, I may have data for June, July, and August, and the next month, it could just be for July and August.

Is there a way to set up my workflow so it can handle these changes automatically, without breaking or requiring manual updates every time the data source changes? I want to ensure my workflow continues to run smoothly even when the input data structure changes.

Regards

Emmanuel Katto

[KGT]

This is a bit late, but the way to do this is to align your metadata to something consistent. The easiest way to do this in your example is using a Transpose with "Dynamic or Unknown Columns" selected in Data. That will put all months into Name/Value and you can work on them all in that format.

Also, posting in General will get less eyes on it than in Designer board.

[OTrieger]

@emmanuelkatto24 

Hello Emmanuel,

Another way will be to use a batch macro that selecting the months and then processing all available months, one by one.