R
Roman Rumisek
Hi,
i have two csv files - control file and data file.
Control file:
Corp_id;corp_name;corp_street;corp_city
100;"corporation";"Street name";"City"
.......
200;"corporation 1"; "Street name 1";"City 1"
and data file:
CustId;First_name;Last_name;Cust_street;Cust_City;Corp_id
1000;"Paul";"Sweet";"Cust street";"Cust City";100
....................
2000;"Jane";"Sweet";"Cust street 1";"Cust City 1";100
...............
I can merged this file in one letter to one corpartion as like this:
Hello,
Corp_name
Corp_street
Corp_city
blablabla
.......
+------+--------+------------+-----------+
|Paul |Sweet |Cust street |Cust City |
....................................................................
|Jane |Sweet |Cust street 1 |Cust City 1 |
+------+--------+------------+-----------+
Best regards,
..................
Any help would be appreciated.
Roman
i have two csv files - control file and data file.
Control file:
Corp_id;corp_name;corp_street;corp_city
100;"corporation";"Street name";"City"
.......
200;"corporation 1"; "Street name 1";"City 1"
and data file:
CustId;First_name;Last_name;Cust_street;Cust_City;Corp_id
1000;"Paul";"Sweet";"Cust street";"Cust City";100
....................
2000;"Jane";"Sweet";"Cust street 1";"Cust City 1";100
...............
I can merged this file in one letter to one corpartion as like this:
Hello,
Corp_name
Corp_street
Corp_city
blablabla
.......
+------+--------+------------+-----------+
|Paul |Sweet |Cust street |Cust City |
....................................................................
|Jane |Sweet |Cust street 1 |Cust City 1 |
+------+--------+------------+-----------+
Best regards,
..................
Any help would be appreciated.
Roman