Re: Merging Multiple Flat Files

[Kirk Goins <kirkgoins@xxxxxxxxx>]

Thaks Coy, I will give that a try and get back to you.

On Thu, Jun 20, 2019 at 4:23 PM Krill, Coy <CKrill@xxxxxxxxxxx> wrote:

> Yes, use a UNION between each select of data from each "flat file". I put
> that in quote because it's not an agreed upon term.
>
> Here is an example:
>
> select datafield
> from flatfile1
> union
> select datafield
> from flatfile2
> union
> select datafield
> from flatfile3
>
>
> Coy Krill
> Core Processing Team Lead
> Washington Trust Bank
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Kirk Goins
> Sent: Thursday, June 20, 2019 14:36
> To: midrange-l@xxxxxxxxxxxxxxxxxx
> Subject: Merging Multiple Flat Files
> Importance: Low
>
>  I have a need to merge multiple flat files into a single file. There is
> duplicate data between the files which I want to remove. Can this be done
> with SQL?
>
> --
> Kirk
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
>
> This electronic mail message and any attachments may contain confidential
> or privileged information and is intended for use solely by the
> above-referenced recipient. Any review, copying, printing, disclosure,
> distribution, or other use by any other person or entity is strictly
> prohibited under applicable law. If you are not the named recipient, or
> believe you have received this message in error, please immediately notify
> the sender by replying to this message and delete the copy you received
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com