Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- set filas=100000; // Number of records to generate
- TPersona:
- LOAD IdPersona
- FROM $(vRutaTransformacionBase)M_Persona.qvd (qvd);
- TMarca:
- LOAD
- Marca,
- CodMarca
- FROM $(vRutaTransformacionBase)M_Marca.qvd (qvd)
- WHERE NOT Match(Marca, 'Diabetes Mellitus', 'Hipertensión', 'Riesgo Cardiovascular Extremo RCE');
- LET vRegistrosPersona=NoOfRows('TPersona');
- LET vRegistrosMarca=NoOfRows('TMarca');
- //CONCATENATE (T_Marcacion)
- LOAD *,
- [Fecha inicio patología] as [Fecha marcación],
- ApplyMap('MAP_CodMarcacion', Patología, Null()) as CodMarca;
- LOAD
- Peek('IdPersona', Floor($(vRegistrosPersona)*Rand())*-1, 'TPersona') as IdPersona,
- MakeDate(Floor(1*rand())+2014)+floor(Rand()*(2*365+1)) as [Fecha inicio patología],
- Peek('Marca', Floor($(vRegistrosMarca)*Rand())*-1, 'TMarca') as Patología
- autogenerate(filas);
- DROP TABLES TPersona, TMarca;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement