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