problem with many joins on same table

[Anonymous]

Hello dear  community:

I'm having a problem when I try to use many  joins on the same table.

For example I concatenate 2 tables, then i have to make 2 left joins to this same table.

The problem is that the second left join doesn't work.

This problem is not only with left joins, but also with inner or outer joins.

Is there a limit of operations that can be made to the same table??

Thanks alot!

[Anonymous]

Thank you!

[#3]

No problem

[marcus_sommer]

Sorry, this was a mistake from me. Meant was:

....

Left Join (workers)

LOAD Distinct ID, Email

FROM [..\External Data\email.xlsx] (ooxml, embedded labels, table is email1);

Concatenate

LOAD Distinct ID, Email

FROM [..\External Data\email.xlsx] (ooxml, embedded labels, table is email2);

- Marcus