topic Re: Function in App Development

Function

Anonymous — Wed, 30 Mar 2016 22:25:00 GMT

Hello All

Can some one tell me the use of concat function

I used the Auto number to make a composite key. Somehow it is not working fine

The purpose of using this is to remove the synthetic key

Please help me

Regards

Deepanshu

Re: Function

swuehl — Wed, 30 Mar 2016 22:29:05 GMT

The Concat() function is used to concatenate text values. It's an aggregation function, so you would typically use a GROUP by clause in a LOAD.

It's used to concatenate text values across multiple records.

If you just want to concatenate field values from the same record, use the string operator &:

FieldA & ' Text' AS NewField

Re: Function

sunny_talwar — Wed, 30 Mar 2016 22:43:11 GMT

In the context of AutoNumber, I think he want to use the & concatenation of fields. But I would propose that you use AutoNumber() instead of & concatenate. What was the issue with AutoNumber? It gave an error? or the results were not as you hoped?

Re: Function

Anonymous — Thu, 31 Mar 2016 02:09:51 GMT

Thanks sir

I have a fact table in which I have different id's like a_Id; b_Id; c_Id and Organization

1st dim table contains a_id ; organization.... Etc

2 nd dim table contains b_Id; organization.... Etc

3 rd dim table contains c_id ; organization... Etc

So I used the auto number to remove the synthetic keys

But somehow result are not fine.

Please suggest what to do...

Thanks

Deepanshu

Re: Function

sunny_talwar — Thu, 31 Mar 2016 09:09:27 GMT

So the results are not what you are hoping for? But are you able to get rid of the synthetic key?

Re: Function

Anonymous — Thu, 31 Mar 2016 09:17:48 GMT

Yes sir...

The result are not appropriate.. But I able to remove synthetic key

Re: Function

sunny_talwar — Thu, 31 Mar 2016 09:19:41 GMT

What is inappropriate about the results you are getting?

Re: Function

swuehl — Thu, 31 Mar 2016 09:20:23 GMT

It's hard to tell what's wrong without knowing

- How you created your keys

- How the data looks like

- What you expect to see

- What you see

So please upload your script and some sample lines of data, or a small sample QVW that can be reloaded (e.g. using INLINE loads).