Find duplicate record and execute code if excel have record or not

Learning Initatives Automation Starter
1

Journal_Number Base_Rate Memo_Amount Transaction_reference Description
156700 1 0 OPERATB GHSHSY
156703 1 0 OPERAMKTSEG FSGUS
156738 1 0 OPERAMGR SHSUU
156749 1 0 OPERAMKTSEG SHSUYIS
156754 1 0 OPERA AR AGING GHSUUID

i have excel which have above record find duplicate record of column Transaction_reference and program is execute if excel is empty

2

Hey!

try this:

dtNew = dt.defaultview.totable(true,"Transaction_reference")

Regards,
NaNi