Forum Discussion

Vermillion23's avatar
Vermillion23
Copper Contributor
Jul 14, 2023

ADF metadata array into conditional single value

Greetings, fellow data people

 

I'm struggling to find the best way to parse a single value from a metadata list of childItems of a folder.

 

As a quick background: I have a dataset pointing to a parent folder, which contains folders (with files inside) for each day, with the naming convention "000271" for today, "000270" for yesterday, and so on. Basically, the highest folder name-number is the most recent folder.

I'm building a pipeline to basically take the highest-number folder each day and paste it into a specified location. The bit I'm struggling with is: while I'm fine getting childItems of the parent folder in the {name, type} array via Get Metadata activity, I'm not sure how to get the highest number folder as output to use as a dynamic parameter for the source dataset for the copy activity.

Any ideas would be extremely valuable.

No RepliesBe the first to reply

Resources