Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Error table Load

Hi,

I Have a query..

How to move error files (xlsx) to error table... If possible to move particular error table.

Thanks,

Mathan

3 Community Answers

Matillion Agent  

Ian Funnell —

Hi Mathan,

You can use the Excel Query component for this purpose.

It copies data from an Excel (.xlsx) file into a target database table.

Best regards,
Ian


Mathan Selvaraj —

Hi lan,

I would like to load error table when files got error. otherwise it can load normal table...

I'm using two tables....

Thanks,

Mathan


Matillion Agent  

Laura Malins —

Hi Mathan

It depends on the errors – by default Matillion will write any error lines to STL_Load_Errors table and you can, of course, bring those across into a Transformation job.

Another option would be to do two passes of your Excel file with your Excel Query component. The first would be a normal load, the second would load all columns into a single column table. You could then use a transformation job to join the two tables together an identify any error rows.

Thanks
Laura

Post Your Community Answer

To add an answer please login