Joining Attendee table and Expense Entry table

[reonainoue]

Hi,

Our company recently implemented data lake and Concur tables are fed every night. 

I was able to join concur report (header), expense entry, payment type, itemization, policy tables. However, I am having a difficulty finding a unique ID column to join expense entry table and attendee table. 

Please let me know how I can join them. 

Thank you!

[KevinD]

@reonainoue I've not heard of data lake, so hopefully someone else on the Community has and can offer some assistance. Did you try reaching out to Concur Support about this? 

[reonainoue]

Hi Kevin,

No, I haven't tried reaching out to Concur Support yet (I'm hoping someone here knows about this). 

Thanks!