Metadata Mismatch-Hash File when Opened in UV stage

[sumeet]

HI ,

I populated a hash file in job1.

I tried to open that hash file through UV stage but when I try to view the data it gives MetaData mismatch. And some columns are missing and some columns have shifted.

Data veiwed from Hash File

col1 col2 col3 col4 col5
M 198905 1989-05-01 1985-05-31 26
M 198910 1989-10-01 1989-10-31 27
M 199006 1990-06-01 1990-06-30 25
M 199009 1990-09-01 1990-09-30 24

Data viewed from UV Stage( column missing & order changed)

col1 col2 col3 col4 col5
198905 -- --- --- M
198910 --- --- --- M
199006 -- --- --- M
199009 -- --- --- M

I checked the metadata..everything looked fine.

What cane be done

Thanks
Sumeet

[gateleys]

What is your source?
Can you save the metadata from the hashed file and load it in the UV stage..and see the results?
Try checking the Position in the UV stage..may be clear the value there.

gateleys

[sumeet]

Hi gateleys,

I load the hash File from Seq File.

And that is what I did..I saved the metadata in Hash file and loaded it in UV stage.

Still it was giving the metadata mismatch.

ANd that is where the problem comes the positions of columns ,when vied from UV stage, seems to have changed.

Thanks
Sumeet

[gateleys]

I just tried it myself, and there was no problem. Can you try using just 2 fields, one for key and another non-key field. Check the Position column in your column definition tab in the UV stage. The key column should correspond to a Postion value of 0 and the other field has 1 (meaning offset in position from the key value).

gateleys

[sumeet]

gateleys ,

I tried it just now, and it worked .

What I did was I made col1,col2,col3,col4 as key in the Hash file, where its getting populated.

then when I viewed the data in UV stage with none of the col marked key , the data seemed to be perfect. I tried with keys in UV stage and they worked fine too.

But I ams till not clear why did this work or earlier thing did not work??

Thanks for taking the initiative
Sumeet

[ray.wurlod]

Answered here