topic Re: Linking 2 databases with the Shopcode, but need also the Year to be linked in QlikView

Linking 2 databases with the Shopcode, but need also the Year to be linked

Mon, 23 Sep 2013 18:44:45 GMT

Hey guys, good afternoon!

I have two database, one from the financial department, and one from Salesforce. In both of them I have "Year", "Month" and "Shop code".

The link between those bases is with the "[Shop Code]", but, When I select "Year=2013", from the financial database, it doesn't filter correctly the Salesforce Year. I use a different name for the Salesforce Year, because when I use the same, circular references are made, and then it doesn't work also correctly.

How do I solve this kind of issue?

Re: Linking 2 databases with the Shopcode, but need also the Year to be linked

Mon, 23 Sep 2013 19:31:47 GMT

try concatenating the fields into one

load shopcode & year as shopcodeyear

Re: Linking 2 databases with the Shopcode, but need also the Year to be linked

Mon, 23 Sep 2013 19:41:31 GMT

I mean, I need to solve it in the script part...

Re: Linking 2 databases with the Shopcode, but need also the Year to be linked

v_iyyappan — Mon, 23 Sep 2013 19:42:34 GMT

Hi,

If you are using same fieldname in Department and SalesForce means concatenate the two table.

for example

Load

Shopcode,

Year(Datefield) As year,

From Department;

Concatenate

Load

Shopcode,

Year(Datefield) As year,

From SalesForce;

Regards,

Re: Linking 2 databases with the Shopcode, but need also the Year to be linked

jemancilla — Mon, 23 Sep 2013 21:10:41 GMT

You can concatenate the fields Year, Month and Shopcode into a new one: "KeyField"

Year & '|' & Month '|' & Shopcode AS KeyField

then, create a link table:

LinkTable:

Load

FieldValue('KeyField',Iterno()) AS KeyField

,Subfield(FieldValue('KeyField',Iterno()),'|',1) AS Year

,Subfield(FieldValue('KeyField',Iterno()),'|',2) AS Month

,Subfield(FieldValue('KeyField',Iterno()),'|',3) AS Shopcode

AutoGenerate 1

While(Len(FieldValue('KeyField',Iterno())))

;