Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
talendtester
Creator III
Creator III

How do I get the output from a .bat using tSystem?

I have a simple .bat job which prints the date time

@echo off echo %date:~10,4%-%date:~4,2%-%date:~7,2% %time:~0,2%:%time:~3,2%:%time:~6,2% exit;

 

I call the .bat job with tSystem component:

command "cmd /c start D:\\myDate.bat"

 

How do I write the returned date time to a file?

I tried all the Standard Output choices but every time a blank line is written to my output file.

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Just to be sure, here is a capture of my tSystem component:

0683p000009Lty6.png

 

 

View solution in original post

4 Replies
TRF
Champion II
Champion II

In tSystem set "Standard Output" to "to Global variable".

Now the result is available from tSystem_2_OUTPUT (in tSystem name is tSystem_2).

You can easily put the result into a file using a tFixedInputFlow connected to a tFileOutputDelimited (for example).

Here is the tFixedInputFlow:0683p000009Lty1.png

Enjoy!

 

talendtester
Creator III
Creator III
Author

Starting a .bat in the Command of tSystem I wasn't able to get it to pass back the output of the .bat.

 

My job looks like: tSystem_1 onSubjobOk  tFixedFlowInput_1>tFileOutputDelimited_1.

 

Apparently the echo date time command must be in the Command of tSystem.

 

 

TRF
Champion II
Champion II

Not necessary. In the example I give, I used a command file, just removed the exit, the rest is copy/paste from your script.
TRF
Champion II
Champion II

Just to be sure, here is a capture of my tSystem component:

0683p000009Lty6.png