Appends: Matching columns with different names?

ksluder · January 15, 2014 11:47AM

I have two data tables that I want to append. I want the column call ID in the first table to match with the column Case ID in the second column. No other columns are in common and I do NOT want to do a join.

Is there a way to select the matching columns?

There are work-arounds but I was hoping for a more straight forward solution.

Thanks,

Kevin

paola · January 15, 2014 12:03PM

Please use the Field Organiser block to rename the field (they have to have the same name before you use the Append block). Append block will slot one data set on top of another, and will preserve any joint fields (in the screenshot below only Date field appears in both datasets) . Watch the video to learn more about this operation:

http://tc.visokio.com/videos/?name=DataManagerAppend&title=Append&lang=gb

ksluder · January 15, 2014 1:43PM

thanks. I wanted to be sure I wasn't missing something

Welcome!

Categories

Ideas Parade

Tagged