Check this: What i have to do to link this 2 queries in data set?

Sure, I will attach it. But it doesn't work for me

Yes, that's right, when running a query in isolation it returns values. I thought of an alternative path. I tried to do this through the data model, linking the FK of hou.name || rcta.attribute15 with Query 2, but I am unable to establish this connection, even though it is the same.

I have this information on ra_customer_trx_all, but when i link them, it's no data found. 

Great! This interaction between the community is really cool.

I have tried this, but it's difficult to find a FK in OTBI side. I'm thinking if that is the best way to execute, or if i should do it by query

I found it, hope that help someone else: TABLE.COLUMN: rbsa.name nome_origem JOIN: rcta.batch_source_seq_id = rbsa.batch_source_seq_id

Excited to learn more about Accelerated Dashboard Creation

@MandeepGupta, This worked perfectly, thank you very much for your help, it was crucial to my analysis.

Hi @MandeepGupta, Indeed, the table you mentioned has the necessary columns, but I couldn't link them to any, and when trying with this join, it doesn't return any data: vJOIN XLE_REGISTRATIONS xl ON xl.location_id = hla.location_id OR JOIN XLE_REGISTRATIONS xl ON ti.FINAL_DISCHARGE_LOCATION_ID