You are not logged in.

SQL on textfile?

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

1

Tuesday, July 17th 2012, 5:22pm

SQL on textfile?

I would like to skip empty lines extracted from a txt file. And the Extract offers to use an optional SQL. But how do I need to name the file in the FROM-statement in this case? I tried some styles (filename with or without the extension..), but nothing works. Some ideas or experiences with doing that?

Best regards,
Stefan Schneider

kratzer

Master

  • "kratzer" is male

Posts: 87

Date of registration: Feb 23rd 2006

Location: Karlsruhe

Occupation: IT

  • Send private message

2

Wednesday, July 18th 2012, 9:06pm

It's the name of your file connection not the file itself! And don't forget the double quotes, Cheers
e.g.:
select "CustomerID","Channel"
from "Orderlines_file"

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

3

Thursday, July 19th 2012, 11:42am

Aahh, I suspected it to be somehow simple, but this obvious style didn't came in my mind... Works fine, thanks a lot.

Best regards,
Stefan

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

4

Sunday, July 22nd 2012, 11:47am

the hardest things are the "s ;-)

tish1

Sage

Posts: 762

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

5

Sunday, July 22nd 2012, 1:35pm

Hi,

the SQL dialect you have to use is Apache Derby's.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

6

Monday, July 23rd 2012, 12:13pm

Hi,
good to know, thanks a lot.
Fortunately, its moreover some Select * From Table - Stuff here... :]

Best regards,
Stefan

Similar threads

Used tags

sql file txt from

Rate this thread