Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0682

D toc

Excerpt

Merges two or more columns of String type to generate output of String type. Optionally, you can insert a delimiter between the merged values.

Info

NOTE: This function behaves exactly like the merge transform, although the syntax is different. See Merge Transform.

 

D s
snippetBasic

String literal reference example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:merge(['Hello,','World'],' ') as:'Hi'

merge(['Hello,','World'],' ')

Output: Returnsthe value Hello, World.

Column reference example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:merge([string1,string2]) as:'merged_strings'

merge([string1,string2])

Output: Returns a single String value that is the merge of string1 and string2 values.

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:merge([string_ref1,string_ref2],'string_delim')

merge([string_ref1,string_ref2],'string_delim')


ArgumentRequired?Data TypeDescription
string_ref1YstringName of first column or first string literal to apply to the function
string_ref2YstringName of second column or second string literal to apply to the function
string_delimNstringOptional delimiter string to insert between column or literal values

D s lang notes

string_ref1, string_ref2

String literal or name of the string column whose elements you want to merge together. You can merge together two or more strings.

D s
snippetusage

Required?Data TypeExample Value
YesString literal or column referencemyString1, myString2

string_delim

Optional string literal to insert between each string that is being merged.

D s
snippetusage

Required?Data TypeExample Value
NoString literal'-'

D s
snippetExamples

Example - Simple merge example

The following example contains the names of a set of American authors. You need to bring together these column values into a new column, called FullName.

Source:

FirstNameLastNameMiddleInitial
JackKerouacL
PaulTherouxE
J.D.Salinger 
PhilipDickK

Transformation:

D trans
RawWrangletrue
p03Value'FullName'
Typestep
WrangleTextderive type:single value:merge([FirstName,MiddleInitial,LastName],' ') as:'FullName'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Valuemerge([FirstName,MiddleInitial,LastName],' ')
p03NameNew column name
SearchTermNew formula

Since the entry for J.D. Salinger has no middle name, you might want to add the following transformation:

D trans
RawWrangletrue
p03Value''
Typestep
WrangleTextreplace col:FullName with:' ' on:' '
p01NameColumn
p01ValueFullName
p02NameFind
p02Value' '
p03NameReplace with
SearchTermReplace text or pattern

Results:

FirstNameLastNameMiddleInitialFullName
JackKerouacLJack L Kerouac
PaulTherouxEPaul E Theroux
J.D.Salinger J.D. Salinger
PhilipDickKPhilip K DIck

Other Examples

While the syntax may be different, the MERGE function behaves exactly like the merge transform. For more examples, see Merge Transform.

D s also
labelstring