Multi value used in hash file
Moderators: chulett, rschirm, roy
Multi value used in hash file
Hello,
want to use the MV in hash files but i don't remember how.
My keys IN are column 1 and column 2 and OUT column 3 and 4.
Knowing that 3 and 4 are S and 1 & 2 MV
Where am i wrong because the stage hash doesn't work ?
Thanks
want to use the MV in hash files but i don't remember how.
My keys IN are column 1 and column 2 and OUT column 3 and 4.
Knowing that 3 and 4 are S and 1 & 2 MV
Where am i wrong because the stage hash doesn't work ?
Thanks
I'm not quite sure of what you are trying to do. Are you asking how discrete values can be extracted, or how they are written?
A hashed file has only one key field, but that can be a multivalue field. Is this the case here?
A hashed file has only one key field, but that can be a multivalue field. Is this the case here?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You remember correctly, in principle that is correct. But I'm still unclear as to which columns contain multivalues and what the lookup is to look like.
Your 1 row source contains how many columns - 4? Columns 1 & 2 have multiple values (separated by what character)?
Your 1 row source contains how many columns - 4? Columns 1 & 2 have multiple values (separated by what character)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Dom?
Ok, So your data contains a key, then you look up a reference hashed file with that key and one MV column with 7 values? And you wish 7 output rows?
Ok, So your data contains a key, then you look up a reference hashed file with that key and one MV column with 7 values? And you wish 7 output rows?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I can't check right now, but I believe you can set a "normalize" drop-down menu in the hashed file stage on a multivalue column.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
All UV tables are hashed files.
Not all hashed files are UV tables. However every hashed file with a consistent record structure can be read as if it were a UV table.
VOC and DS_JOBOBJECTS are examples of hashed files that do not have consistent record structure.
Not all hashed files are UV tables. However every hashed file with a consistent record structure can be read as if it were a UV table.
VOC and DS_JOBOBJECTS are examples of hashed files that do not have consistent record structure.
Last edited by ray.wurlod on Tue Jul 23, 2013 4:43 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.