Export utility - left outer join?

Yahoo Archive
1
Wayne,

This is a very quick and easy report in report builder with vendor and
vendor group. Join is left outer and use "company" and "group code". The
ones without group description will appear with a ?

Jim Frice

> -----Original Message-----
> From: Wayne Cox [mailto:wmc@...]
> Sent: Wednesday, September 13, 2000 3:15 PM
> To: vantage@egroups.com
> Subject: [Vantage] Export utility - left outer join ???

> Hmm, been spending a bunch of time messing with the export utility this
> afternoon, and just fired up email after a couple hours. Looks like
> someone else is having the same struggle today :)
>
> I'm having decent luck making simple exports work. But doing joins is
> giving me headaches. I want to dump all vendors, along with their
> GroupCode and VendGrup.Description. Some Vendors don't have a group code
> (that's where the trouble starts)
>
> for each Vendor Where Vendor.Company = cur-comp no-lock,
> each vendgrup of vendor:
>
> Behaves like an Inner Join and DOES NOT export the Vendors with a null
> GroupCode.
>
> Other stuff I tried generated run time errors, or duplicated vendors X
> every VendGrup, and other useless stuff.
>
> Can anyone tell me how to make it behave like a Left Outer Join ?
>
>
> Thanks, -Wayne Cox
>
> PS... just to make things more aggravating, Vantage leaves the export
> file locked sometimes, so you have to rename it with each try. arrgh!
>
>
2
Regardless of the Vantage version you're using, the Query Wizard in the
export system is pretty straightforward... You'll be asked three questions:

1. What table(s) contain the data you want to export. If you specify more
than one table, the system will warn you that a join will be made.
2. The system will prompt you for the fields you want to filter by. If you
don't want to filter the data, just click next. Otherwise, you will be
prompted for the filtering criteria.
3. You'll be asked for fields upon which you want the data to be sorted.
Again, if sorting is unimportant to you, just click next. Otherwise, find
the sort field and select it.

After this last choice, click finish. Vantage will write the query. In 4.0,
the query tab will show you the resultant query as written. The fields tab
will allow you to select the fields you want exported.

Vantage only writes Excel v2.1 files, which are pretty far removed from
current versions of the software. The biggest difference is that v2.1 files
don't support multiple tabs (worksheets) within the same workbook. I'd
recommend saving the spreadsheet in the most current file format that your
system supports.

In general, exports are a great way to get massive amounts of data quickly.
Vantage 3.0 works the same as v4.0; it's just not as pretty.

-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Wednesday, September 13, 2000 10:08 AM
Subject: [Vantage] Exporting Part Numbers
---------------------------------------------------------------------_->

I'm not exactly sure what is involved in the query area. I understand the
Options and Fields areas but not the Query area. Do you have the time to
explain it?

Thanks!

Wendy Pursche
3
Hmm, been spending a bunch of time messing with the export utility this
afternoon, and just fired up email after a couple hours. Looks like
someone else is having the same struggle today :)

I'm having decent luck making simple exports work. But doing joins is
giving me headaches. I want to dump all vendors, along with their
GroupCode and VendGrup.Description. Some Vendors don't have a group code
(that's where the trouble starts)

for each Vendor Where Vendor.Company = cur-comp no-lock,
each vendgrup of vendor:

Behaves like an Inner Join and DOES NOT export the Vendors with a null
GroupCode.

Other stuff I tried generated run time errors, or duplicated vendors X
every VendGrup, and other useless stuff.

Can anyone tell me how to make it behave like a Left Outer Join ?


Thanks, -Wayne Cox

PS... just to make things more aggravating, Vantage leaves the export
file locked sometimes, so you have to rename it with each try. arrgh!