|
Rank: Member
Joined: 7/23/2018 Posts: 11 Location: London
|
Hi there I am sorry to trouble you all
I am really struggling with one to many data input.
for example
I have client transactions stored in one excel file
eg NumeroPolice Transaction no Polcode LapPolicyNo Full Name 8AAMX01RR01 2 RR LAP/B08/075410 Mr Muhammad 8ABDU01RR01 2 RR LAP/B08/075474 Abdul 8ABGX01RR01 2 RR LAP/B08/075410 Mr Gary
policy number and transaction numbers are unique key
I also have a another file where vehicle details are stored.
NumeroPolice NumeroAvenant Vehicle reg 8AAMX01RR01 2 YX59XPC 8AAMX01RR01 2 KY65RYW 8AAMX01RR01 2 T88MNA 8AAMX01RR01 2 AK53CWN 8AAMX01RR01 2 GD65NWY 8AAMX01RR01 4 YX58XPC 8AAMX01RR01 4 KY64RYW 8AAMX01RR01 4 T88MNA 8AAMX01RR01 4 AK55CWN 8AAMX01RR01 4 VE65UVC 8ABDU01RR01 2 BK10EGD 8ABDU01RR01 2 VE65UVC 8ABDU01RR01 4 BK12EGD 8ABDU01RR01 4 W631VCP 8ABGX01RR01 2 BP51BBE 8ABGX01RR01 2 EO56VCX 8ABGX01RR01 2 FL12WNH 8ABGX01RR01 2 VE61UVC
now my problem is
when I run the schema I wanted to show one client policy may have few vehicles record
I also attached the file for your attention
kind regards Sharma
File Attachment(s): altova.docx (94kb) downloaded 264 time(s).
|
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 563
|
If you're trying to use that lower Excel component as a look-up, you're definitely doing it wrong. File Attachment(s): example.zip (3kb) downloaded 258 time(s).
K101 attached the following image(s):
|
|
Rank: Member
Joined: 7/23/2018 Posts: 11 Location: London
|
Hi Many many thanks I will give it a go and come back to you much appreciate your help kind regards Sharma
|
|
Rank: Member
Joined: 7/23/2018 Posts: 11 Location: London
|
Hi I am definitely making progress ....! since there is two primary key
the first match is client policy number = vehicle policy number
then client transaction no = vehicle transaction number
if the first matches and second does not, then it should treat it as a new record.
any help please many thanks sharma
|
|
Rank: Member
Joined: 7/23/2018 Posts: 11 Location: London
|
Hi I am definitely making progress ....! since there is two primary key
the first match is client policy number = vehicle policy number
then client transaction no = vehicle transaction number
if the first matches and second does not, then it should treat it as a new record.
any help please many thanks sharma
|
|
Rank: Member
Joined: 7/23/2018 Posts: 11 Location: London
|
Hi I am getting error message called execution failed out of memory
any advice on this please thanks sharma
|
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
Your input file is probably very big. Install 64 bit of Altova software and try again
|
|
guest |