Merge FitBit Data based on Date and Id

[Kritikagupta]

Hello everyone, 

I am struggling a little in merging 3 tables into one which has ID and Date as a common field.

Attaching the screenshot and data.

I would greatly appreciate any help.

Thanks

Kritika

[ChrisTX]

Your second Join field, the date, has Null values for every record in every table.  So each Null value will join to every other Null value.  Likely not what you want.

Chris

[Kritikagupta]

ohh ok - Here's the attached data and it has dates. I am not sure, how you find null values.

[ChrisTX · Accepted solution]

Your Select tools are changing your Date values to Null.  Look at the Conversion errors in the attached screenshot.

Your date is formatted MM/DD/YYYY, so you can't simply use a Select tool to change the format from String to Date.   To only use a Select tool, the text would need to be in the YYYY-MM-DD format.

Under the Parse palette, try the DateTime tool to convert your date value (coming in as String) to data type Date.  See attached example.

Not sure what's wrong with the Community today.  I can't paste in screenshots, I have to attach them.

Chris

[nagakavyasri · Accepted solution]

[Kritikagupta]

Great, thanks for the help :)

[Kritikagupta]

After Merging, how come the unique Ids are 33.. it should be 24?