TWO TABLES - CREATE ONE RESIDENT TABLE

[KWHITEHURST]

I'm sure one of you lovely experts can help me please.

I have two loaded tables and i need to create a resident table using data from both tables.  see below
i am needing to create a 'Tier' field which would be an If statement (rows 31-33 on screenshot) which uses a variation of 3 fields across two tables.  I've spent a fair few hours on this, to no avail 😞

[Filipe]

Bom dia @KWHITEHURST  se você tiver algum campo em comum poderia usar algum dos "join" para unir as informações.

[Or]

Generally this is done by creating a single table (using Join or Concatenate as appropriate), and then applying the condition in that table. If one of the tables is just a lookup, you can consider using a Mapping Load to simplify.