I have a situation where I have a CSV that contains a bunch of data that populates a bunch of related tables with FK constraints directly. Thats no problem. The problem is that one of the columns specifies a filepath to an XML file that is supposed
to contain data to be populated in a table with an FK constraint. How do I specify the file name to the XML source component at runtime?
TableA has columns:
TableB has columns
TableBID TableAID (FK to Table A) MemberID (the data in question)
TableA has a 1 to many relationship with Table B.
The CSV has a bunch of columns including:
TableAID File path to list of members for each group.
I don't know how to solve this problem. I tried using a ForEach ... but I couldn't get it to work.
Thanks in advance for any assistance.
View Complete Post