cancel
Showing results for 
Search instead for 
Did you mean: 
reonainoue
Occasional Member - Level 1

Joining Attendee table and Expense Entry table

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!

2 REPLIES 2
KevinD
Community Manager
Community Manager

@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? 


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
reonainoue
Occasional Member - Level 1

Hi Kevin,

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

 

Thanks!