Data Warehousing and Data integration

Reading Excel File

More

3 years 6 months ago #22359 by hanisultan

Reading Excel File was created by hanisultan

Is it possible to read from Excel file until an empty row is found - see attached

Attachments:

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

More

3 years 6 months ago #22361 by Peter.Jonson

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/advanced-etl-proc...laneous/concatenate/

Trim value
/wiki/advanced-etl-processor/transformation-functions/strings/trim/

Abort the execution on an empty value
(Is null or empty string)
www.etl-tools.com/wiki/advanced-etl-proc...ation-rules/strings/

Peter Jonson
ETL Developer

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

More

3 years 6 months ago #22363 by hanisultan

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

Attachments:

The following user(s) said Thank You: Peter.Jonson

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