CSV files with Date Column and Others with no Date Column - How to combine them?

Options
jrod31
jrod31 Registered Posts: 14

Hi,

I have several CSV files in a 2024 folder that feeds into DataIku. These files have a date column already. The new files that I will be adding to this folder will not have a date column.

Example:

Existing files -
Column A | Column B | Column C
02-10-2024 | Name | Product

New files
Column A | Column B | Column C
Name | Product | ID#

Can I have DataIku add a date value and move the Name value, Product value and ID# over to the right?
I know I could create a new dataset and add the date column and merge the datasets after, but I was wondering if there was another way of doing it before making the build more complex.

Thanks,


Operating system used: Windows

Tagged:

Answers

Setup Info
    Tags
      Help me…