topic Re: Join (mapping) table in loading script in App Development

Join (mapping) table in loading script

irmantas — Wed, 01 Dec 2021 20:48:51 GMT

Hello, everyone,

Need help in joining tables, or mapping table for adjust some data. Situation: I am loading main table with a lot of columns from data source (.xls), and need join other (Adjustment) table of two colummns. If the key (ProdId) are in both tables need change Producer meaning in Main table.
Example:

When does a script have to be written for the data to load properly?

Re: Join (mapping) table in loading script

Or — Wed, 01 Dec 2021 21:51:35 GMT

This is easier to achieve using a mapping load, though you could join the tables and then make a second load pass to pick out the producer from Adjustment if you so prefer. For mapping:

Adjustment:

Mapping Load ProdId, Producer as Producer_For_Map

From AdjustmentTable;

Main:

Load ProdId, TransDate, QTY, applymap('Adjustment',ProdId,Producer) as Producer

From MainTable;

Re: Join (mapping) table in loading script

irmantas — Thu, 02 Dec 2021 19:21:05 GMT

Thank you, it's works