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 Solved logic help for excel to sql mapping.

More
02 Dec 2016 07:46 - 18 Apr 2017 09:25 #1 by Prashant.Sangle
Prashant.Sangle created the topic: logic help for excel to sql mapping.
Hi,

I need your help to implement below logic.

I have 5 excel source file at different location.(All files having same structure.)

I want to map it to one target location with below condition.
1: If any of the field in source target table contain null
- Execution stop for that file and send alert mail for that file.
- and start executing next file.

Should I create 5 different mapping for every excel??
Can write sql operation on excel metadata?

Let me know if any additional information required.

Regads,
Prashant
Last Edit: 18 Apr 2017 09:25 by Prashant.Sangle. Reason: Issue solved.
More
02 Dec 2016 18:12 - 02 Dec 2016 18:13 #2 by Thomas BLETON
Thomas BLETON replied the topic: logic help for excel to sql mapping.
Hi,
You don't need to create 5 metadatas. Your excel files have the same structure, so simply use one metatada and specify a variable in the excel file path.
For example: jdbc:stambia:excel://${~myfilepath}$?forceDatatypeAsString=true&...

This way, you can design only one mapping, and call it from an ExecuteDelivery action, passing the "myfilepath" value in the action's parameters.
FileWait  (list excel files)
    |
    | (bind link)
    |
    v
ExecuteDelivery (myfilepath: :{FILE_DIR}:/:{FILE_NAME}:)
(sorry for the ASCII art, I can't do a screenshot right now ;-))
Last Edit: 02 Dec 2016 18:13 by Thomas BLETON.