I have two datasets that I'm trying to Union using dataprep. Both have 300+ columns and require a combination of matching by name and manually adding columns to match since the names aren't always the same.
After matching the columns and saving, the job fails everytime at the 5 minute mark. After it fails and I try to go back into the recipe to check the matched columns, the columns that I matched are no longer matched.
Any solutions or additional steps to fix this would be helpful.
Thanks!