Concatenation for Measures in Direct query for Postgresql

[Anonymous]

Hi All,

As per heading of the discussion, I want to concatenate string values in two different columns of Measures in Direct Query.

How Can I achieve the same.

I am using Postgresql.

I am using -

DIRECT QUERY

DIMENSION

  1 As Flag

MEASURE

  col1,

  col2,

  col3

From demo;

And I want something like -

DIRECT QUERY

DIMENSION

  1 As Flag

MEASURE

  col1,

  col2 || col3 as test

From demo;

Please assist.

Thanks & Regards,

MK

[Anonymous]

It throws an error while Reloading saying -

No Direct statement

[sunny_talwar]

Made a mistake earlier, try it with single quotes within the Native function

[Anonymous]

The example is for Dimension, I want to use the same for Measures.

I am using Postgresql, and when we use the same syntax, it throws an error

[sunny_talwar · Accepted solution]

I see no documentation where it says that you cannot use NATIVE in Measures. But there is no way for me to test this because I don't have access to Direct Discovery application. But just so we are sure, did you add single quotes around your function?

NATIVE( 'col2 || col3' ) as test

[Anonymous]

Thanks sunny,

The reload was successful, but in the Table when I fetch the test column, it says -

"direct query failed"

Any inuts

[Anonymous]

Thanks sunny,

The reload was successful, but in the Table when I fetch the test column, it says -

"direct query failed"

Any inuts