ETL-Tools.Com
× Data Warehousing and Data integration

Reading Excel File

  • Posts: 693
  • Karma: 1
  • Thank you received: 6

Reading Excel File was created by hanisultan

Is it possible to read from Excel file until an empty row is found - see attached
1 month 3 weeks ago #22359
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1305
  • Karma: 3
  • Thank you received: 166

Replied by Peter.Jonson on topic Reading Excel File

Yes it is possible

Add validator object
Combine all fields into one using concatenate
www.etl-tools.com/wiki/aetle/transformat...llaneous/concatenate

Trim value
www.etl-tools.com/wiki/aetle/transformat...nctions/strings/trim

Abort the execution on an empty value
(Is null or empty string)
www.etl-tools.com/wiki/aetle/validation_rules/strings
Peter Jonson
ETL Developer
1 month 3 weeks ago #22361

Please Log in or Create an account to join the conversation.

  • Posts: 693
  • Karma: 1
  • Thank you received: 6

Replied by hanisultan on topic Reading Excel File

Thank you - I was actually able to do it with just the validator and is Null or Empty function and it worked
The following user(s) said Thank You: Peter.Jonson
1 month 3 weeks ago #22363
Attachments:

Please Log in or Create an account to join the conversation.

Copyright © 2022 ETL-tools.com. All Rights Reserved.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies

Read More