How get and combined column from another dataset using magicETL

Jez · November 26

Dataset A columns: Name, Bday, Age, Gender, City Address, Country

Dataset B columns: Name, Position, Salary, Company

columns I only want and will name as DatasetC: Name, Bday, Age, Position, Salary

I am thinking if I can just use Dataset B, save as Dataset C and add columns (Name, Bday, Age) from Dataset A. But I don't know how. Please help.

Thank you!

ColemenWilson · November 26

You will need to join the datasets on Name. Name is not a great join key. If you have a unique ID that would be better. Also when joining it would probably be good to ensure that case matches by using LOWER() function on Name in both datasets. Again, name is not a great join key, so if there are other options use those. If you provide some sample data I can show you what the dataflow would look like in Magic ETL.

I walked through how to do this here: https://www.loom.com/share/65f86c7dd1bd46ffa64e9036c03a20bb?sid=6ed0ec21-507d-4589-b416-57a5dc82b4cb

ColemenWilson · November 26

I walked through how to do this here: https://www.loom.com/share/65f86c7dd1bd46ffa64e9036c03a20bb?sid=6ed0ec21-507d-4589-b416-57a5dc82b4cb

ColemenWilson · November 26

You will need to join the datasets on Name. Name is not a great join key. If you have a unique ID that would be better. Also when joining it would probably be good to ensure that case matches by using LOWER() function on Name in both datasets. Again, name is not a great join key, so if there are other options use those. If you provide some sample data I can show you what the dataflow would look like in Magic ETL.

I walked through how to do this here: https://www.loom.com/share/65f86c7dd1bd46ffa64e9036c03a20bb?sid=6ed0ec21-507d-4589-b416-57a5dc82b4cb

ColemenWilson · November 26

I walked through how to do this here: https://www.loom.com/share/65f86c7dd1bd46ffa64e9036c03a20bb?sid=6ed0ec21-507d-4589-b416-57a5dc82b4cb

Jez · November 27

This works! Thanks a lot coach @ColemenWilson

How get and combined column from another dataset using magicETL

Best Answers

Answers

Categories