distinct

[raadwiptec]

hi all,

I have a large script..where data is loaded from multiple QVD's.. where iam using Load disctinct.. now iam including using applymap an addition column which has non distinct values and has to be considered..

For ex:

Load distinct

...

...

..

the above load alwasys has distinct values.. but the new column will not have ..so when include this column also i get distinct...

[sangeess21]

Can you please upload a sample file?

Thanks,

Sangeetha

[vinieme12]

Are you asking ? or is this the problem you are facing?

[buzzy996]

i do not think so it's possible the way u think through applymap on sample distinct table load.

u can do one way,remove distinct key work on ur main table that will fetch all values and use distinct key work on ur chart level wherever distinct values u need.

[raadwiptec · Accepted solution]

thanks guys i have solved this... in a different way.. something like no concatenate.. and using first load as full lload and later follow with distinct...

hi vinneth  yes..it was a problem facing...