I have an simple Azure Data Factory project aiming to copy data from an external service (Service Now) to an Azure Table Storage.
To keep things simple, consider source dataset only as an id and a creation Date:
ID, CreationDate
1 , 2020-05-02T10:00:00
2 , 2020-05-02T11:00:00
I want to copy it to the Azure Table with the same structure/columns, but I want to extract date from datetime column to use as Partition Key, and use the ID as Row Key (if possible, still maintaining the original ID column).
I think I need to use some expression to get the column values mapped to Partition/RowKey, but I didnĀ“t found any expression that help me.
@formatDateTime(????source.CreationDate????, 'yyyy-MM-dd')
Thanks in advance for any help with the correct expression for this scenario.
Regards,