topic Re: inline in QlikView

inline

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a columns called code in a atable having values 03,04, etc

Iam trying to inner join a table with inline value

INNER JOIN LOAD * INLINE [

Value1, Code

03 03

];

but it is not joining

Re: inline

marcus_sommer — Fri, 08 Jul 2016 14:44:28 GMT

Between your values "03" is no comma as delimiter and you might need to specify the table to which you want to join.

- Marcus

Re: inline

sunny_talwar — Fri, 08 Jul 2016 14:44:39 GMT

Are you getting any errors? Also, it is always a good practice to name the table you are joining this to.

Inner Join (TableName)

LOAD * INLINE [

Value1, Code

03, 03

];

Also remember, the end result will be only those rows where the matching field has values in the TableName table. Is this really what you want?

Re: inline

Anonymous — Fri, 08 Jul 2016 14:46:29 GMT

It looks like you just need something like

Table A:

Load *

from sourcefile

join (Table A)

load * inline [

Value,Code

03,03

];

Can you share your app or script as the column in your inline load statement seem strange and I'm not sure what it is your trying to achieve. What should your data model look like?

Re: inline

raadwiptec — Fri, 08 Jul 2016 15:03:48 GMT

HI Marcus,

there is comma between in actual script. i missed it here in the discussion

hi sunny,

no errors. but it does not show the join in the data model

hi brian,

the qvw is very big.. iam just trying to join with small inline table..

Re: inline

sunny_talwar — Fri, 08 Jul 2016 15:09:09 GMT

Data model won't show 2 tables, I hope you are not looking for two tables, are you? Since you have joined them together, All the fields (on which you have not joined) will be part of the table you have joined them on

Re: inline

raadwiptec — Fri, 08 Jul 2016 15:10:33 GMT

iam not looking for 2 tables. but a link between value and code.

Re: inline

sunny_talwar — Fri, 08 Jul 2016 15:13:40 GMT

How does the table you join into looks like? What are all the field names?

Re: inline

Colin-Albert — Fri, 08 Jul 2016 15:34:33 GMT

Your example has one table with two columns Value1 and Code, you have not specified any other table that you are trying to join these values to. The two values 03 03 need to have a comma separator to load correctly 03, 03

Perhaps if you added more that one row to your inline table it would become clearer how QlikView is processing your data.

In the majority of cases with QlikView there is no need to use joins.

If any tables have fields with the same name they will be associated and the data is linked in the data model automatically.

Have a look here for more details Understanding Join and Concatenate | Qlikview Cookbook

Re: inline

raadwiptec — Fri, 08 Jul 2016 18:46:13 GMT

Table1:

Load

Product,

Code

Description,

Year,

Month,

Country

From ......products.xlsx

My second datais a multiheader excel file and iam uisng certain @ concepts to load this values as

for ex :@1 ,@2 and further changing these to column names.

now to forcefully give a relationship between 2 files iam adding an inline table and further iam trying linking the code values to value1 of inline..

I have done this for Year and Month and it works good.

INNER JOIN LOAD * INLINE [

Value1, Code

03 03

];