Ask the Expert

Creating a query in Info 6

I am in SQ01. I have a few employees in Info 6 Address with their permanent address missing. How can I create a query that will give me only those employees with Info 6 where their permanent address is blank?

    Requires Free Membership to View

If you are using the Infoset Query functionality in BW I would suggest using other tools like LISTCUBE or the Query Designer if the data you're after is in an InfoProvider. Regardless, when running your Infoset Query you want to return only blanks for the address field. To do so, make sure the address is a "Selection Field" when you create the query. Then when executing, right-click in the address drop-down field, choose "Options" and pick "Not Equal to." Execute and you will only return records where the permanent address field is blank.

This was first published in October 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: