Hi,
I have one derived column setid, from source let say two cols pol_year, id.
My requirement is like if the first record pol_year,id value <> previos record pol_year,id value then setid should increse else previous set id.
I am using hash file to read the o/p and comparing the previous val. But I am not getting
can any one suggest with correct code
Link Collector
Moderators: chulett, rschirm, roy
Key marked in Hash file will eliminate duplicates. So if you have the same values of the key, it will be eliminated.
You can sort the data based on the two fields. Use Transformer stage variable to compare the previous record value and assign the Set_Id.
If you search for Previous records manipulation in transformer, you will get an idea of how to use the stage variable to check it.
You can sort the data based on the two fields. Use Transformer stage variable to compare the previous record value and assign the Set_Id.
If you search for Previous records manipulation in transformer, you will get an idea of how to use the stage variable to check it.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Re: Link Collector
Does your post have anything to do with the subject of your post (Link Collector)??
In what order do your columns arrive? And how are they supposed to be sorted?
You may want to check the functions -
RowProcCompareWithPreviousValue() and RowProcGetPreviousValue(). You could use them in stage variables to compare the current concatenated values of pol_year and id to the previous.
In what order do your columns arrive? And how are they supposed to be sorted?
You may want to check the functions -
RowProcCompareWithPreviousValue() and RowProcGetPreviousValue(). You could use them in stage variables to compare the current concatenated values of pol_year and id to the previous.
gateleys