Alternative of Concatenation

[beck_bakytbek]

Hi Folks,

i have a question, namely my situation does look like,

Unqualify *;

DateLink1:

Load

Personal.MK as Link,

Personal.MK.JM as Link_Date,

Personal.MK_Amount as Link_Amount,

'PK' as Link_DateType

Resident Personal;

Unqualify *;

tab2:

Load

FDL.MK as Link,

FDL.MK.JM as Link_Date,

FDL.MK_Amount as Link_Amount,

'FDL' as Link_DateType

Resident FDL;

after reloading my data will be matched into one table, it does work great, but i think, it could be a better way to connect the tables within script-area.

Does have anybody any idea?

Beck

[vinieme12]

"it could be a better way to connect the tables within script-area"

Not sure exactly what are you trying to achieve here?

[avinashelite]

Above script won't concatenate the tables because Link_Date and Link_Datum different filed name so it will yield in the synthetic key ..are you using force concatenate ?

[beck_bakytbek]

Hi Vineeth,

first of all thanks a lot for your feedback,

i showed here a part from script, i do this in script-area, as you know if 2 tables have the same fields names, they will be automaticaly matched to one table.

this part of my example does work great, i just want to know, are there an another way of concatenation of 2 tables within of script area?

Beck

[Anil_Babu_Samineni]

Remove Unqualify and check

[beck_bakytbek]

Hi Avinash,

thanks for your responce, i corrected the mistake in my example,

[vinieme12]

You don't need the Unqualify statement, just the below will do for Auto Concatenation

DateLink1:

Load

Personal.MK as Link,

Personal.MK.JM as Link_Date,

Personal.MK_Amount as Link_Amount,

'PK' as Link_DateType

Resident Personal;

tab2:

Load

FDL.MK as Link,

FDL.MK.JM as Link_Date,

FDL.MK_Amount as Link_Amount,

'FDL' as Link_DateType

Resident FDL;

[avinashelite · Accepted solution]

"another way of concatenation of 2 tables within of script area?"

1.if your intention is to concatenate 2 tables then its already happening rite ? whats the issue with that ....

2.If you don't want the table to be concatenated then use the Qualifier * ;

3.if you want the tables to be kept separate and connect the tables then create composite keys in the tables and rename the field 

[beck_bakytbek]

Vineeth, Ani Babu, Avinash

thank a lot guys for your feedback, very helpful

[avinashelite]

If you have got answer mark the correct answer and close this thread