Visokio website     Downloads     Video tutorials     KnowledgeBase  
DataManager: Merging using 'OR' function - Visokio Forums
DataManager: Merging using 'OR' function
  •     ALC September 4, 2015 6:44AM
    HI

    I am wanting to merge two files based on an ID. In the first file the ID's are all found with in the same column however in the second file the ID could be in one of 14 different columns. Is it possible to do all this in one merge block? The merge blocks enable you to add more than one criteria but this doesn't work as it is then trying to match the ID to two different columns. I could create 14 merge blocks, each with an equal and then append but this looks very messy
    thanks, Anna
  • 3 Comments
  •     paola September 4, 2015 7:23AM
    It might be more efficient if you created a formula field that will harvest, then park the ID, so you can proceed with the merge.
    Ordinary plus function should enable you to add contents of multiple horizontal cells, assuming only one of them contains the ID, others are empty?
  •        daniel September 4, 2015 7:27AM
    How about de-pivoting the second list? If you can turn those 14 columns into rows so that all the ID are in just one column?
    Omniscope Hobbyist:
    - https://www.linkedin.com/in/dancklam
    - http://spatiametrics.wordpress.com/omniscope-data-visualisations
  •     ALC September 4, 2015 7:53AM
    Using the depivoting function works. The other columns in the data set weren't all empty, sometimes the were multiple ID's (different) but in the same row. However all fixed and working now - Thanks
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged