Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

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
logic help for excel to sql mapping. was created by Prashant.Sangle
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
Replied by Thomas BLETON on 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.