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.