Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question Mapping with Analytic functions

More
15 Jun 2016 14:04 #1 by letancel
letancel created the topic: Mapping with Analytic functions
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
More
17 Jun 2016 22:24 #2 by Thomas BLETON
Thomas BLETON replied the 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 ?