Sharepoint Files with Different Field Counts, but Same Field Names

Options
munoj9
munoj9 Dataiku DSS Core Designer, Registered Posts: 6

Hello everyone,

I am currently importing files from SharePoint that are sent to me via email on a weekly basis.

Each file may have a different number of fields each time it is sent.

I notices that Dataiku is not appending on the name each time and simply creating null values on the fields that arent visible on each dataset.

Instead it pushes values to the left to fill columns in.

example:

data1.csv

name,lastname,money,activity

jj,mounts,1000,100

data2.csv

name,lastname,activity

jj,mounts,100

sharepoint dataset built in dataiku

name lastname money activity

jj mounts 1000 100

jj mounts 100

the above result would be wrong and its what Dataiku is doing.

It should have filled money with a blank and activity with 100

How can i fix this error?

Answers

Setup Info
    Tags
      Help me…