I have a custom field in Request table in spooling the record from xtraction but its spooling ID and not the list. pls see 3 snapshots below for better understanfing
I have attached a document, that I made some time ago, that should help you in setting up what is needed in Xtraction.
Please review and let me known.
Is the Zvendorlist, within SDM referencing a table?
if the ID is from a table, the zvendorlist table needs to be defined to Xtraction.
Then a join needs to be setup that maps the zvendorlist to the request table.
this setup would be similar in Xtraction when looking up priority/analyst/affected end user
pls see atttached 3 snapshots... i have already joined this table on
request table on xtractiin?.
On Wed, Nov 21, 2018, 8:30 PM davidanegrey <
I understand, that is great, but from your shots, something is still missing.
Within the zvendorlist table, is the list defined?
can you post how the zvendorlist is defined in Xtraction?
Is there a field in zvendorlist table for the list field?
Yes the list is defined as i hided it with blue as in screenshot 3
zvendorlist defined in xtraction ...u can see snapshot 2.
Pls help to provide more information to you
Does the zvendorlist table defined in Xtraction look like this
The ZvendorList List, should then show up under columns...
Does this help
I havent done this.. How can i define this in xtraction.. pls help.
try this link and see if it helps Part 10 Working with Data Sources
Can you work with me on this if raise a support issue for this? because this is still not done and we have many custom table in sdm and we need this on xtraction for reporting.
can you support for one field through webex? so i can share case number?
have a question for you.
Have you added a join statement, to the table that the z field is in.
I have to check about the webex. let me check on this..
where are you located / time zone...
yes i did
im located in pakistan. GMT +5
Many thanks..seeking your support.
hmmm, a bit of time difference, I in eastern US, on EST.. GMT -5
I will try to put together a guide and submit to you...
I have done this many times... it is just probably something little missing....
thanks and cheers
many thanks for your co operation . This will help me.
or if not , you can make any convenient time to look on webex , i will manage.
However, case already been opened but not resolved yet and the support is advising to post on community.:)
1) REQUEST.ZVENDORLIST - is a custom field in the Request Table.
2) Which table is the ZVENDORLIST sym/display in?
3) Did you create a custom table to hold the values for ZVENDORLIST?
In xtraction? NO i havent defined this table in xtraction.
Can you please guide on this becoz i can see how to add table but there are more tabs/option under it like FIELDS , JOIN & FILTERS...
Thanks for the document and i followed what you have mentioned in the document but still its getting ID.
I created Table in xtraction and add the fields in it. after that i called that field in Request table and also join the table with xutom table in xtraction. But still same issue. May be there is little might be im missing still.
Can you PLEASE take a webex for this, Case # 01338109
I can be available on your prefer timings. please let me know.
also the i have same issue for another custom table (SREL) for agt (Analyst contact) and Location (SREL) for which im getting invalid value in xtraction record. I will be expecting you webex time.
Hi David. im now able to resolve this issuie
Glad to hear, you got this all working....
Retrieving data ...