DSXchange

Hello everybody!
I would like to compare two intput files.

I have two xml file.
If the contents of two files is identical,i want to reject the file or stop the job.

Somebody has an idea please?

1)
In fact,i used the xsd (with xmlspy) and i defined the minLen and maxLen of th field.
My field is a string 14--> minLen=1 and maxLen=14
If the field is null the job stop.
2)
But i can use a transformer for the null element as you told me Ernie.

thank you very much Ernie.

hello i used xmlspy for editing my xsd: my xsd: <?xml version="1.0" encoding="UTF-8"?> <!-- edited with XMLSpy v2010 (http://www.altova.com) by Bf --> <!--W3C Schema generated by XMLSpy v2010 (http://www.altova.com)--> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema&qu...

Hello, I want to check nullabilities in my xml file.(i use an xsd file) All my field are not nullable. But when i used xml input,my final file is generated with few field empty. I want when a field is null the job stop or a warning inform me. In fact it's working for few field but not all why? examp...

it works.

Thank you very much.

Hi everybody! I want to fill a field with spaces, my schema file is: record {final_delim=end, record_length=fixed, delim=';', quote=none} ( Type_de_document:string[6]; Identifiant_partenaire:string[3]; NIM:string[7]; NIL:string[7]; NID:string[7]; Date_debut_compte_actif:nullable string[14] {null_fie...

Thanks Ernie.

I had one more element in the Xpath of the XMLOutput.

I resolve my problem of "&amp",don't put "/" in join. Now I have : <Point_passage> <Test>Rang=1 NIM= Libelle_point= Critere= </Test> <Test>Rang=2 NIM= Libelle_point=Critere=</Test> <Test>Rang=3 NIM= Libelle_point= Critere=</Test> </Point_passage> I wish to have: <Point_passa...

I resolve my problem of "&amp",don't put "/" in join. Now I have : <Point_passage> <Test>Rang=1 NIM= Libelle_point= Critere= </Test> <Test>Rang=2 NIM= Libelle_point=Critere=</Test> <Test>Rang=3 NIM= Libelle_point= Critere=</Test> </Point_passage> I wish to have: <Point_passag...

Hi, Finally i have a xml file that i wanted but there is some problems. I used a transformer for regroup columns in order to repeat this in xml file example: my columns are: -Rang -NIM -Libelle_point -Critere I used the transformer stage for concat them into a column "RANG_XML": "RANG...

Thanks for your help

Hi, I generated a xml file like: <Jour_ouverture>Date_debut_effet="2007-09-10" Date_fin_effet="2009-11-26" Jour="SAMEDI" Plage_ouverture="06:00 - 20:00"</Jour_ouverture> I wish to tranform it like this: <Jour_ouverture Date_debut_effet="2007-09-10" D...

Finally i resolved my problem it was a key in the xml output,i uncheck it and it's working.

Thanks Ernie I change the repetition element key and in the transformer i used the hash for this key.I have an another problem the group "jour_ouverture" is repeat for the block "aller" and the block "retour", the problem is that this group must be at the end of file :?...

Hi, I used xml best practice but i have a problem with xml repetition my file should like this : - <Flux_ref_destinataire> <Caracteristique_flux Date_generation="2009-08-21T18:30:00" NIM_REMETTANT="" Code_codif="0000" /> - <Information_destinataire Code_Remettant="...