join two tables

[#1]

I have attaching the sample of two tables i need to join both.

signupavtivity table

client_id

user_id

email_type_id

user_signed

invitation_id

useractivity table

client_id

user_id

email_type_id

i need to join the above two table.

I am using a below script:

LOAD `invitation_id`,

    `user_signed`,

    landing_page_accessed,

    referrer_email_type_id as email_type_id,

    SQL SELECT `invitation_id`,

     referrer_email_type_id,

    `user_signed`,

    `FROM rcdbprod.SIGNUPACTIVITYLOG WHERE client_id in (6,12,13,15,16,3,8,10,18);

join

LOAD

    user_id,

    status as email_type_id;

SQL SELECT

     user_id,

    status

FROM rcdbprod.USERACTIVITYLOG where status in (2,3,4,8);

after i join the rows added from useractivity is not have the values in columns invitation_id,user_signed,client_id.

how can i add, after i join it has to take all the values for the respective field through user_id.

In signupactivitylog i am not able to add the user_id. if i add the user_id it is showing sync table error.

i need the count of email_type_id for particular client.

Regards,

Pramod

[#2]

HI Sinan,

I am attaching the image of data model view.

Please check and help on it.

Thanks,

Pramod

[sinanozdemir]

Hey Kumar,

Can you do the below in both DateBridge and Signupactivitylog tables?

DateBridge:

invitation_id as invit_id

Signupactivitylog:

invitation_id,

invitation_id as invit_id

So I think Signupactivitylog table is being referenced by the same field twice, that could be the reason so you are totally renaming invitation_id to invit_id in DateBridge table and you are keeping invitation_id in Signupactivitylog, but bringing it again and renaming it to invit_id. As a result of this, DateBridge gets hooked onto Signupactivitylog on invit_id and Signupactivitylog gets hooked onto Coursecompletion on invitation_id.

Hope this helps if not, would you mind attaching qvd? of course if it is not confidential.

Thanks

[#4]

Hi Sinan,

Thanks for the reply.

I checked with it now i am getting new sync table with different fields.

Sync1= DateType + canonical date;

Sorry i am not able tp post the .qvf.

Regards,

Pramod

[sinanozdemir]

Hi Kumar,

Can you post your data model again with the above changes?

Thanks