How to use copy rows selectively with rules

Overview

Copy rows selectively is one of the most widely used file instruction in SolveXia instructions library. It offers to copy rows that matches configured set of criteria. Instruction can copies multiple rows including duplicate rows from source to target when all specified conditions are met. Copy rows selectively

  • Does not check for duplicate values in source
  • Does not require to match criteria in target to paste the rows
  • Runs successfully if no rows matches to specified source conditions
For the purpose of this article we are going to use a simple and fictitious example of a source and target excel files. You will want to replace reference to the source & target excel files with files of your own.

For example, Copy rows selectively can copy selectively rows where (1) column C is equal to “TRUE” and (2) Column F is not equal to Female. Rest of the article explains how to configure the Copy rows selectively instruction to achieve result shows in Target file.

Steps

  • Load process
  • Turn on Design mode
  • Load file manipulation step
  • Click on blue text “No instruction has been selected yet, click here to select an instruction”
  • Click on ‘Excel group’, when popup opens with list of instructions
  • Select Copy rows selectively
  • Once you select Copy rows selectively, step will display controls to configure an instruction with values
  • Click on Link button to ‘Link’ source Excel workbook from where you wish to copy rows. Once you click on ‘Link’ a file searcher will be opened that allows you to select an Excel file
  • Select Excel file, and click on Choose the selected item button at the bottom right corner of the file searcher. This action will link file in the source section
  • Now click on Link button of target section to link an excel workbook. Repeat step 9 and choose target workbook
  • Click on drop down button, and select source worksheet name from the drop down list
  • Click on Address drop down list and select ‘Advance range’ option to specify the source range
  • Enter ‘From Cell’ address as ‘A2’
  • Click on drop down list in To Cell, select Last Cell in Col option, and enter column ‘A’ in first text box, and column ‘F’ in ‘as far as’ text box
  • In target section, click on target worksheet drop down list, and select target worksheet
  • Select Advance range option in the target section
  • Select the Address in From Cell option, and enter ‘I1’ as starting cell address from where instruction should start pasting selected rows
  • Select To fit source data option in ‘To Cell’ option

    Now in parameter section, you can configure set of conditions to be met for source rows to be copied to target file. Instruction contains a default condition that you can use. This example shows how to configure 2 conditions.
  • Enter column name C in the Column text box
  • Click on drop down list to select an operator. Select Equal operator for this example. You can choose any operator from the list
  • Enter value that should be checked in the condition
  • Click on Add button to add another condition, and repeat step 19 to 21 to configure second condition
  • Click on Save button to save step configuration
  • Once step details are saved, click on Run button to start running the step

    At this point rows will be copied to target worksheet.
  • Click on Download button to download a file, and view target worksheet
  • You will see following outcome for the above configured conditions
Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox