Function

[Anonymous]

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

[swuehl]

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

[sunny_talwar]

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?

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

Yes sir...

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

[sunny_talwar]

What is inappropriate about the results you are getting?

[swuehl]

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).