How to add the partition name to a row

Nick_Pedersen

Hi community.

I have a dataset that is partitioned on the sub file name e.g. "2023-04-03.xlsx". But there is no columns in the dataset that relates the individual row to the partition file its coming from. It would make it easier to work with the data in the FLOW, if I could add a column that holds the subfile name. Is there a way to do that?

---

Operating system used: IOS

AshleyW

Hi @Nick_Pedersen
,

You might try the 'enrich with record context' processor in the Prepare recipe. You should be able to add partition information with it.

Cheers,

Ashley

Nick_Pedersen

Hi @AshleyW
,

I successfully managed to add the partition info. Thank you SO much for your help. Really appreciate it.