pentaho-kettle-8.3 ETL数据开发

id;name;firstname;zip;city;birthdate;street;housenr;stateCode;state 1;aies-name;wkh-firstname; 17420;qqr-city;1986/07/31;ihjh-street; 426;OH;OHIO 2;yxcm-name;ydl-firstname; 19780;ovt-city;1978/09/27;fjnn-street; 387;CT;CONNECTICUT 3;jgbk-name;gou-firstname; 17460;rmb-city;1966/06/16;kivo-street; 296;IA;IOWA 4;gimo-name;kok-firstname; 15240;erw-city;1970/06/29;oqrx-street; 127;PR;PUERTO RICO 5;bxjq-name;hrx-firstname; 15480;emq-city;1974/07/15;sxni-street; 21;NH;NEW HAMPSHIRE 6;wepp-name;ogv-firstname; 11420;gdw-city;1950/07/14;aqsn-street; 209;SD;SOUTH DAKOTA 7;ddyr-name;kup-firstname; 15200;cib-city;1982/10/27;puik-street; 115;UT;UTAH 8;vfbx-name;cwj-firstname; 19140;hls-city;1966/03/01;ubty-street; 421;FM;FEDERATED STATES OF MICRONESIA 9;yeun-name;mxf-firstname; 16860;ctq-city;1966/10/20;sdxa-street; 3;IL;ILLINOIS 10;glmm-name;ppg-firstname; 13680;nvn-city;1970/06/07;xziv-street; 360;TX;TEXAS 11;ojvm-name;hkn-firstname; 19580;vkq-city;1954/09/20;nexd-street; 93;TN;TENNESSEE 12;pepy-name;nfi-firstname; 16060;tjd-city;1966/11/30;pmtr-street; 485;TX;TEXAS 13;zaer-name;aop-firstname; 18080;mll-city;1982/06/29;eigo-street; 422;MO;MISSOURI 14;mycp-name;gke-firstname; 15760;tyu-city;1970/02/25;sabz-street; 186;AZ;ARIZONA 15;cfcx-name;qln-firstname; 15980;gls-city;1982/05/04;qgam-street; 139;DE;DELAWARE 16;hrmi-name;ddy-firstname; 13180;aig-city;1954/11/02;bihw-street; 373;AS;AMERICAN SAMOA 17;bego-name;mes-firstname; 19940;mpo-city;1974/08/05;cfbp-street; 140;MA;MASSACHUSETTS 18;oefi-name;ezx-firstname; 12240;bdw-city;1974/03/02;nfez-street; 280;NH;NEW HAMPSHIRE 19;velw-name;ppd-firstname; 11640;nws-city;1950/04/24;yyri-street; 336;RI;RHODE ISLAND 20;cypv-name;sry-firstname; 16460;mnc-city;1954/08/04;ymcq-street; 230;GU;GUAM 21;kozv-name;abr-firstname; 16820;sbr-city;1990/02/17;asli-street; 156;MT;MONTANA 22;sleh-name;cla-firstname; 14100;ryj-city;1982/08/25;bhnc-street; 294;IA;IOWA 23;csnd-name;set-firstname; 13580;iyq-city;1970/05/01;wwbd-street; 497;TN;TENNESSEE 24;wzss-name;dcw-firstname; 10620;zag-city;1990/02/01;qlrw-street; 371;WY;WYOMING 25;dsca-name;cpn-firstname; 14160;qec-city;1962/11/17;wcvf-street; 467;PW;PALAU 26;oubd-name;idh-firstname; 19000;icw-city;1986/05/20;uxze-street; 344;MH;MARSHALL ISLANDS 27;hkcf-name;hqw-firstname; 17080;fld-city;1982/09/28;cshr-street; 397;IN;INDIANA 28;bend-name;qdp-firstname; 11200;mbg-city;1986/08/11;irdw-street; 92;AR;ARKANSAS 29;rpck-name;fii-firstname; 19340;wic-city;1975/01/17;tgui-street; 218;IA;IOWA 30;kufj-name;mce-firstname; 16320;vse-city;1978/12/03;cxqs-street; 283;VA;VIRGINIA 31;rmvb-name;pnm-firstname; 10100;fsc-city;1954/05/03;qapr-street; 414;MS;MISSISSIPPI 32;byzf-name;gak-firstname; 13740;ojy-city;1970/09/01;hwnq-street; 453;TX;TEXAS 33;dguq-name;psf-firstname; 10880;afd-city;1982/04/29;gdvc-street; 406;WA;WASHINGTON 34;nifd-name;ijl-firstname; 11740;zpy-city;1986/02/12;vuro-street; 64;ME;MAINE 35;svhb-name;bcp-firstname; 18560;tws-city;1982/09/05;ihqd-street; 339;MA;MASSACHUSETTS 36;wyrb-name;zxx-firstname; 14980;aqp-city;1966/08/01;cmkn-street; 292;CA;CALIFORNIA 37;hytp-name;swa-firstname; 11020;gma-city;1982/10/02;qtdw-street; 358;ID;IDAHO 38;owyg-name;sgl-firstname; 16300;xrc-city;1974/05/29;flrn-street; 470;OH;OHIO 39;xhng-name;rki-firstname; 17300;yhv-city;1970/09/09;wsdu-street; 101;NY;NEW YORK 40;vkbm-name;uei-firstname; 11120;pns-city;1990/10/08;dhfi-street; 221;CO;COLORADO 41;vaiu-name;ewy-firstname; 16420;emz-city;1966/09/21;nzlp-street; 260;DC;DISTRICT OF COLUMBIA 42;lnad-name;oex-firstname; 15120;zdr-city;1978/06/23;gnwf-street; 432;SC;SOUTH CAROLINA 43;ihuz-name;xyz-firstname; 12080;jue-city;1954/02/18;hmtt-street; 159;RI;RHODE ISLAND 44;tkcs-name;qex-firstname; 18220;ewv-city;1954/10/10;xfls-street; 349;DE;DELAWARE 45;zhif-name;fat-firstname; 12440;qzx-city;1966/10/12;mzxp-street; 477;CO;COLORADO 46;edry-name;acs-firstname; 10700;yye-city;1958/11/19;bzvy-street; 215;SC;SOUTH CAROLINA 47;uedd-name;lna-firstname; 17100;bqz-city;1978/07/21;ykiw-street; 306;AZ;ARIZONA 48;fkls-name;ebp-firstname; 19580;rxx-city;1966/02/11;uatf-street; 476;HI;HAWAII 49;qlks-name;jrc-firstname; 15500;zoy-city;1990/01/10;hlwm-street; 411;KY;KENTUCKY 50;lvrv-name;waq-firstname; 15720;hdn-city;1979/01/01;awvg-street; 201;SC;SOUTH CAROLINA 51;mmbm-name;kdf-firstname; 13660;zvs-city;1990/10/26;uxgv-street; 148;FL;FLORIDA 52;zjhs-name;ijp-firstname; 15240;kgq-city;1970/06/03;nicn-street; 29;FL;FLORIDA 53;nmaq-name;aah-firstname; 18960;cbu-city;1978/03/28;rszp-street; 151;DC;DISTRICT OF COLUMBIA 54;ioub-name;uxc-firstname; 10420;tiq-city;1962/10/02;tzyv-street; 20;CA;CALIFORNIA 55;ndrf-name;yzv-firstname; 14400;upy-city;1962/11/11;gdhz-street; 489;DC;DISTRICT OF COLUMBIA 56;blqd-name;xmq-firstname; 18600;opo-city;1978/10/24;aqmf-street; 466;GA;GEORGIA 57;bjle-name;hkh-firstname; 17240;rxc-city;1974/06/29;elul-street; 162;WV;WEST VIRGINIA 58;fhlo-name;vjr-firstname; 19640;ewj-city;1966/03/25;ydpn-street; 299;ID;IDAHO 59;qkms-name;rgt-firstname; 18500;xxm-city;1970/08/18;orkh-street; 385;OR;OREGON 60;hdcn-name;ykr-firstname; 14980;scz-city;1962/04/03;amyd-street; 410;MI;MICHIGAN 61;lzsy-name;evy-firstname; 13160;rgo-city;1974/09/24;jvag-street; 270;MT;MONTANA 62;fxpf-name;cjq-firstname; 14300;pph-city;1970/08/26;dmcp-street; 249;MO;MISSOURI 63;dxgo-name;vev-firstname; 12580;eao-city;1958/04/03;ljdq-street; 121;MT;MONTANA 64;dzon-name;ymo-firstname; 17380;mvp-city;1978/04/15;fvev-street; 270;IA;IOWA 65;zyef-name;qrr-firstname; 13800;sbh-city;1986/05/22;uhed-street; 186;VT;VERMONT 66;bdbl-name;nij-firstname; 12560;oap-city;1990/09/10;yvkd-street; 365;TX;TEXAS 67;soqq-name;fsg-firstname; 12580;psk-city;1970/03/22;mmaj-street; 344;WY;WYOMING 68;puwk-name;yoi-firstname; 14220;tqa-city;1986/03/01;zger-street; 74;PA;PENNSYLVANIA 69;buyk-name;rrh-firstname; 19520;ueq-city;1974/10/14;aysa-street; 315;ND;NORTH DAKOTA 70;rads-name;oxw-firstname; 15520;oaa-city;1950/02/02;qjvp-street; 477;PR;PUERTO RICO 71;ndyr-name;qat-firstname; 11300;pur-city;1978/06/12;ohnf-street; 117;UT;UTAH 72;lgpl-name;jtw-firstname; 14220;ibd-city;1990/09/28;ppqi-street; 301;DC;DISTRICT OF COLUMBIA 73;ifkf-name;lkj-firstname; 11340;acm-city;1954/05/28;smcy-street; 116;OH;OHIO 74;ycji-name;fzu-firstname; 12420;xca-city;1950/04/08;dtjn-street; 405;MI;MICHIGAN 75;mbrn-name;owd-firstname; 16860;qpj-city;1970/07/04;eexk-street; 140;NJ;NEW JERSEY 76;ukyg-name;eer-firstname; 13280;jqb-city;1986/05/10;fqlq-street; 422;KS;KANSAS 77;alid-name;fol-firstname; 11700;ivw-city;1966/06/30;epoy-street; 246;IA;IOWA 78;cqre-name;fwb-firstname; 10500;ocp-city;1982/08/01;bulp-street; 466;NE;NEBRASKA 79;ktcj-name;yet-firstname; 16940;hft-city;1978/06/23;yfth-street; 381;DE;DELAWARE 80;rfoz-name;byc-firstname; 18500;rsf-city;1978/01/04;grzc-street; 436;undefined;undefined 81;euti-name;laf-firstname; 13500;qmg-city;1950/08/24;xdhn-street; 248;AK;ALASKA 82;umam-name;wjm-firstname; 14380;tqq-city;1982/08/25;naop-street; 84;MP;NORTHERN MARIANA ISLANDS 83;mhkj-name;ipy-firstname; 13900;hsm-city;1970/06/18;peja-street; 385;VA;VIRGINIA 84;cyke-name;obe-firstname; 14240;hzv-city;1970/09/26;nkfh-street; 119;NJ;NEW JERSEY 85;qjge-name;yyi-firstname; 12400;qvt-city;1970/11/23;mxop-street; 27;MT;MONTANA 86;fmax-name;uvk-firstname; 10100;aru-city;1958/07/18;ugkt-street; 259;ME;MAINE 87;unnd-name;fzs-firstname; 15560;mxy-city;1966/09/05;okwr-street; 484;WV;WEST VIRGINIA 88;cxxp-name;wue-firstname; 15200;xvq-city;1974/05/10;uztj-street; 267;ID;IDAHO 89;vuey-name;pax-firstname; 17520;iwo-city;1966/04/03;ninf-street; 373;KY;KENTUCKY 90;eayi-name;zrf-firstname; 18520;iab-city;1978/08/25;ssxg-street; 131;PR;PUERTO RICO 91;xjyz-name;odg-firstname; 17040;vbs-city;1954/10/25;wlcn-street; 184;FM;FEDERATED STATES OF MICRONESIA 92;hxws-name;rue-firstname; 11660;fqy-city;1966/09/30;zbco-street; 157;ME;MAINE 93;ujmm-name;reh-firstname; 15500;zat-city;1958/03/14;xyoj-street; 267;UT;UTAH 94;jehc-name;lno-