Order of Operation

[Anonymous]

I am struggling with something that does not make any sense.

My use case:

1) Log into google Drive

2) Extract a csv file

3) create that file in the processing folder

4) Upsert that file data to Salesforce

When I pull the file like this:

It creates the file as a csv in the intended directory.

As soon as I do this:

The file is only created as a blank file and I cannot read the data.

I need to be able to read through and transform the data in order to set up the correct records.

Any help is appreciated.

[DataTeam1]

Are you sure that the path in each tFileDelimited... component is the same?

Try to use tHash... components instead of tFileDelimited... to be sure that process is correct.

Here you can find info about tHash components.

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/LTqBBurBnnkWIPVTY769dA

[Anonymous]

Hi,

    Two items could be the reason here. First, I would suggest you to change the flow to OnSubJobOk as it is more ideal.

Another thing I noticed is that you are writing the data to same file"InvestmentBookingProcessing" through reject flow. Please make sure that you are not writing and reading from same file in same subjob. You can use Append mode as an option but I prefer to load any reject records back to original file in separate step.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂