Limit a field in one table based off of a field in another table

[hjm35055]

Hi,

I have 2 tables.  Table 1 contains 'PeriodID' and Table 2 contains 'Period'.  Table 1 will always have one more period in it than Table 2 (contra account).  How can I limit Table 1 to be <= the periods in Table 2 so I do not see the extra period?

Thank you,

[swuehl]

The values are identical (so we are not talking about numeric IDs versus text values)?

You can for example load Table 2 first, then

LOAD *

FROM Table1

WHERE EXISTS(Period, PeriodID);

[aarkay29]

This may be helpful

Exists - script function ‒ Qlik Sense