I want the rows in files to be loaded into database with the same order as they exist in the files!

Highlighted
Five Stars

I want the rows in files to be loaded into database with the same order as they exist in the files!

I have loaded some files into a BigQuery table. The problem is, the order of the rows in the table is different from that of in the files. The same files were previously loaded into a Postgresql table with the same ordering but BigQuery behaves different apparently. Is there a way of forcing the natural row order at the load time?

Moderator

Re: I want the rows in files to be loaded into database with the same order as they exist in the files!

Hello,

Would you mind posting your current job design screenshots on forum?

Can you please clarify in which Talend version/edition you are?

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read