Skip to main content
Solved

InlineQuerier query

  • September 5, 2018
  • 4 replies
  • 114 views
A
Forum|alt.badge.img+1

Hi

I am trying to use the InlineQuerier for the first time. I am using it instead of FeatureMerger because I want to do a join using a Like statement with wildcards which is not possible with FeatureMerger.

However I can't work out why my query is not running. I have done the same query within Oracle SQL Developer and it worked, but it is not working in InlineQuerier.

The query I've tried is below but I get a "Format and Dataset Unspecified" error when I try to run it.

SELECT b."POSTCODE",a."POSTCODE_AREA"

 

FROM "OS_POSTCODE_UNITS" b

 

INNER JOIN "TABLE1" a ON REPLACE (b."POSTCODE", ' ', '') LIKE CONCAT(REPLACE (a."POSTCODE_AREA", ' ', ''), '%');

Screenshot is also included.

I believe I have not set up the InlineQuerier properly in terms of the Input and Outputs, but I am struggling to understand what I am supposed to put here. Does anyone have a step-by-step example of how to use this transformer?

Regards,

Best answer by ebygomm

I don't think SQLite which the inlinequerier uses supports CONCAT try || instead

SELECT b."POSTCODE",a."POSTCODE_AREA"
FROM "OS_POSTCODE_UNITS" b
INNER JOIN "TABLE1" a ON REPLACE (b."POSTCODE", ' ', '') LIKE REPLACE (a."POSTCODE_AREA", ' ', '')||'%'

If you could post a sample of your source datasets someone may be able to advise further.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3429 replies
  • Best Answer
  • September 5, 2018

I don't think SQLite which the inlinequerier uses supports CONCAT try || instead

SELECT b."POSTCODE",a."POSTCODE_AREA"
FROM "OS_POSTCODE_UNITS" b
INNER JOIN "TABLE1" a ON REPLACE (b."POSTCODE", ' ', '') LIKE REPLACE (a."POSTCODE_AREA", ' ', '')||'%'

If you could post a sample of your source datasets someone may be able to advise further.

A
Forum|alt.badge.img+1
  • aquamarine
  • Author
  • 271 replies
  • September 5, 2018

I don't think SQLite which the inlinequerier uses supports CONCAT try || instead

SELECT b."POSTCODE",a."POSTCODE_AREA"
FROM "OS_POSTCODE_UNITS" b
INNER JOIN "TABLE1" a ON REPLACE (b."POSTCODE", ' ', '') LIKE REPLACE (a."POSTCODE_AREA", ' ', '')||'%'

If you could post a sample of your source datasets someone may be able to advise further.

Thanks @egomm

 

 I have changed the code to use the || operator instead but I still get the same error.  I have attached a screen shot of the Inputs and Outputs.  Are these set up correctly?

 

 

inlinequerier2.jpg, 

 

 

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3429 replies
  • September 5, 2018
Thanks @egomm

 

I have changed the code to use the || operator instead but I still get the same error. I have attached a screen shot of the Inputs and Outputs. Are these set up correctly?

 

 

inlinequerier2.jpg,

 

 

Ah, that Run... button has never worked for me, I just run the workspace to see if it works
A
Forum|alt.badge.img+1
  • aquamarine
  • Author
  • 271 replies
  • September 5, 2018
Ah, that Run... button has never worked for me, I just run the workspace to see if it works
oh you are right! it does work even though the 'Run' button failed :) Thanks!

 

 

Community Stats

32,084
Posts
121,839
Replies
39,723
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.