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 isdate dosen't work ?

More
13 Feb 2019 14:32 #1 by merzouk
merzouk created the topic: isdate dosen't work ?
Est ce que la fonction isDate() fonctionne sur stambia ?
je l'ai utilisé dans une condition mais elle ne fait pas les rejets.

Is the function isDate () running on stambia?
I used it in one condition but it does not make rejections.
More
13 Feb 2019 18:13 #2 by Thomas BLETON
Thomas BLETON replied the topic: isdate dosen't work ?
Hello,
Can you specify which "isDate" function you are referring to?
Is it a database function?
Can you show with a screenshot where you are trying to use it, and how?
More
14 Feb 2019 11:34 #3 by merzouk
merzouk replied the topic: isdate dosen't work ?
Attachments:
More
14 Feb 2019 13:50 #4 by Thomas BLETON
Thomas BLETON replied the topic: isdate dosen't work ?
OK, this metadata looks correct. Can you confirm this is a Sql Server table ? or another database ?
Is there an error or simply the mapping is ignoring the Rule ?
How is your mapping configured? Is the "Enable rejects" checkbox enabled on the target?
Can you verify that the SQL query looks correct in the Reject step?
More
14 Feb 2019 15:21 #5 by merzouk
merzouk replied the topic: isdate dosen't work ?
Hello,
yes thi is sql server
simply the mapping is ignoring the Rule
Attachments:
More
14 Feb 2019 15:49 #6 by Thomas BLETON
Thomas BLETON replied the topic: isdate dosen't work ?
The mapping looks correct too.
Can you show a sample data which should be rejected, from the source File ?
And this question is important : can you verify that the SQL query looks correct in the Reject step, I mean can you see your isDate() function in the generated SQL statements ?
More
15 Feb 2019 16:59 #7 by merzouk
merzouk replied the topic: isdate dosen't work ?
Bonjour,
j'ai trouvé la source du problème. le mapping n'était pas sauvegardé.
merci pour votre aide