Put in an Excel file the result of my query if it only brings back information

[TDIALLO]

Hi,

I have a process that consists of putting the result of my query in an Excel file if it only brings back information (See diagram below)

I did this which works fine

Except that my technical referent doesn't want to see two tMysqlInput components follow each other so I tried a tMysqlRow but it brings me back null while my query does bring back a row.

Do you have any idea how i can do this please,

Thank you in advance for your help

*****************************Français*******************************

Bonjour

j'ai un un traitement qui consiste à Mettre dans un fichier Excel le résultat de ma requête si elle ramène de l'information uniquement(Voir schéma ci-dessous)

J'ai fait ceci qui fonctionne bien

Sauf que mon référent technique ne veut pas voir deux composant tMysqlInput se suivre donc j'ai essayé un tMysqlRow mais il me ramène du null alors que ma requête ramène bien une ligne.

Avez-vous une idée de comment je peux faire ça svp,

Merci par avance de votre aide

[Anonymous]

Hi

tMysqlRow does not have a pre-defined global variable like ((Integer)globalMap.get("tDBInput_1_NB_LINE")) on tMysqlInput, so it is null when you using the global variable.

Usually, we use a tDBInput to run a select statement, not the tDBRow component. In this case, you can add a dummy component tJavaRow after the first tDBInput component to make the job be more readable, eg:

tMysqlInput1--main--tJavaRow--runIf--tMysqlInput2--main--tFileOutputDelimited.

Regards

Shong

[TDIALLO]

Hello Shong,

Thank you for this feedback, I did the same thing as your proposal but he wants something else and not two tDBInputs

Thank you for your proposition

[Anonymous]

In my experience there is no better way than using tDBInput component. 😉

[TDIALLO]

🙏