Union of list of tables

Comments

3 comments

  • Avatar
    Gerry Mullin

    It sounds like a Do While would work and you could keep on appending your logic to a brd file that you finally read when the loop has completed.

    I'm attaching an example of how I would configure a Do While that would cycle through a list of 5 tables.

     

    Attached files

    Loop - 6 Sept 2018.lna

     

    0
    Comment actions Permalink
  • Avatar
    Holger Schimanski

    Thank you very much for providing a demo workflow! :-)

    I notice, that you are using the Output BRD File node and not the CAT node.

    But my input tables have slightly different column structures.

    CAT has ConcatenationMode = Union ("Outputs all of the fields across the inputs, filling in nulls for fields not present in a given input"), but Output BRD File with Append = True ("If true and the output file exists, the field names and types of the existing file and the input stream are compared to make sure they are identical.") does not accept different columns.

    Any ideas?

    Best regards
    Holger

    0
    Comment actions Permalink
  • Avatar
    Gerry Mullin

    Rather than using Append, I added reading back in the BRD file and then using Cat (union) to join back up to the current iteration. Then we will overwrite a new BRD file each time. That will get you past that error.

     

    Attached files

    Loop with Cat (Union) - 7 Sept 2018.lna

     

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk