New Join Worksheets by Column Tool

Version: 2022

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-23712,ORG-21914

From main menu Worksheet: Join Worksheets by Column will open this new tool.

  • Support two input worksheets to be joined.

  • Support multiple matching columns.

  • Support drop non-matches and drop multiples for each input sheet.

  • Support drop multiples by merged value.

  • Support sort output by specified column.

  • Support output additional info to column label to indicate different source.

  • Support query language like SQL to join columns. See following example,

    wjoincols -r 2 irng:=([Book1]Sheet1,[Book2]Sheet1) 
    query:="w1 inner join w2 on w1.A=w2.A and w1.B=w2.B order by match asc w1 merge multiples by first row";
    //Join method supported: Inner Join, Left Join, Right Join, Full Outer Join