Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

MAx value for a column

i have fact table with lots of data...I have claim value ,policy number ,policy expiry date , policy date like columns in the table. i need to take max of claim value where file should be  latest fi...
Need Help
Show and Tell
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

usually information below is needed, could you provide it? Thanks.

 (1) a sample file, you can replace raw data with bogus data to protect your privacy.

     or provide some sample data that fully covers your issue/question.

(2) give your expected result based on the sample you provide. If calculation formula is involved, please provide it.

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.