 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Comparision... | Login/Join |
| Platinum Member |
I have a test box...there i will type the Invoice Nums...(Comma separated). And i have a metadata column, where all the Invoice Nums are stored. I want to find out the Invoice Nums which does not exist. Can anybody create a example on EMP_ID in Employee table and pass on ??This message has been edited. Last edited by: Kerry, WF Server: 7.1.4 on Z/OS and Linux, ReportCaster Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K WF Client: Servlet, CGI | ||
|
| Platinum Member |
Tony, I know u can help me here !! WF Server: 7.1.4 on Z/OS and Linux, ReportCaster Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K WF Client: Servlet, CGI | |||
|
| Virtuoso |
Maybe lack of response is because the question isn't very clear. Your typing comma spearated invoice numbers into what? a file? a launch form? And then is it supposed to compare against something else like all values in a table? Can you give us an example of what you're trying to do to help clarify your question? Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Expert |
Hmmm, I think I could as well, if it didn't seem so much of a demand. Have you actually tried anything at all yet? or are you just waiting for someone to do it for you? T | |||
|
| <JG> |
Tony, I'm sure you have an appropriate daily rate you could apply. | ||
|
| Virtuoso |
test box - What? Is this a machine, a field, a text area, a .... metadata column - you mean a field in a database table I guess? Find out which numbers do not exist - in the database as compared to the entry, or the other way around? If you type in the numbers in a html field that will get transported to webfocus as 1 &var, and if you want to find out which typed numbers are not in the database, you could do the following (rough steps): 1. build a repeat loop that will do a gettok for the next number 2. if no more number then exit the repeatloop, otherwise write the number to an intermediate file. 3. write a master file for the intermediate file with the numbers 4. do a MATCH FILE for the intermediate file and the database field, and do a AFTER MATCH HOLD OLD 5. Lastly, filter the hold file for records that have no value for the database field. Hope this helps... GamP
| |||||||||
| ||||||||||
| Expert |
I sure do JG, as I am sure you do!  GamP, I think he means text-box. T | |||
|
| Expert |
I suspect GamP is on the money, but this sort of thing is simple stuff. I would bet virtual money that there are other examples in this forum already. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |