Welcome Guest! Log in

Topic-icon Question Mapping with Analytic functions

More
15 Jun 2016 14:04 #1 by letancel
Mapping with Analytic functions was created by letancel
Hi,

I'd like to use an analytic function in a column of my mapping :
first_value(extranet_retour.valeur_colonne)
over (partition by
		extranet_retour.nom_page,
		extranet_retour.id_tiers,
		extranet_retour.nom_colonne
		order by extranet_retour.datetime_log desc)

When I execute the mapping I get an exception during the build sequence : Exception : Fatal error during transformation
I tried the same query with SQL Server Management Studio and it worked well, so it's not a syntax issue..

Are the analytic functions known to Stambia?

Thanks

Please Log in or Create an account to join the conversation.

More
17 Jun 2016 22:24 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Mapping with Analytic functions
Hi,
Analytics function can be used.
Are you sure the error is due to this expression ? If you replace it with width a simple <table>.<columnname> then it works ?

Please Log in or Create an account to join the conversation.