Transforming an ETL

oliviafiorillo
oliviafiorillo Member
edited December 11 in Magic ETL

Hello!

I am trying to edit an ETL with three input datasets..

My goal is to get the 'GLAcct' row of data from the "GLAC PARTS (EZ TEST)' input dataset into the GLBD_V2 datset.

Currently, the join is taking the 'GLAcct' under the input dataset 'GLBD_v2'.

The request I received was to add a column onto one of our cards referring to this data. This column refers to a certain GLAcct that is in the GLAC PARTS (EZ TEST) data set.

I do not want to make any other changes to the ETL (everything else is working just fine), so that is why I have not made any changes yet.

image.png

Fore more context: The join is currently a Left Outer with the left table being the GLAcct from the GLBD table.

image.png

Would anyone be willing to help or inform my team and I if there would be a way to go about this without making too drastic of a change? Let me know if I need to provide more context.

Tagged:

Best Answer

  • ggenovese
    ggenovese Contributor
    Answer ✓

    Hello - If you want to take an entire row from one dataset and add it to another then you need to Append rather than Join. If you're concerned about alterations to the existing ETL I would recommend making a copy of the ETL to test the logic and then incorporating your changes into the original ETL when you're satisfied with the results.

Answers

  • ggenovese
    ggenovese Contributor
    Answer ✓

    Hello - If you want to take an entire row from one dataset and add it to another then you need to Append rather than Join. If you're concerned about alterations to the existing ETL I would recommend making a copy of the ETL to test the logic and then incorporating your changes into the original ETL when you're satisfied with the results.

Categories