When you push from Sterling to ITX, it overrides the adapter (Excel) to Stream, so it will not work. You need to send the Excel spreadsheet in Stream, write to a local file (local to ITX) and then kick off another map to read that file using the Excel adapter.
@@PaulBrettTech If you write to a local file on the ITX with a fixed file name, then at the same time in another session, the same file name will be saved, and the data will be the same, but if you write a dynamic file name, the Command line command: -F test .xlsx -W Sheet1 will not dynamically fill in the file name in place of test.xlsx. thanks
Can you make an example to get an excel sheet on sterling b2b and push it into the ITX? Currently, when I get it, there is no data. Thanks
When you push from Sterling to ITX, it overrides the adapter (Excel) to Stream, so it will not work. You need to send the Excel spreadsheet in Stream, write to a local file (local to ITX) and then kick off another map to read that file using the Excel adapter.
@@PaulBrettTech If you write to a local file on the ITX with a fixed file name, then at the same time in another session, the same file name will be saved, and the data will be the same, but if you write a dynamic file name, the Command line command: -F test .xlsx -W Sheet1 will not dynamically fill in the file name in place of test.xlsx. thanks
Hi Paul, is there any way i can install ITX in my personal computer?
Talk to Product Management.