inline

[raadwiptec]

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

[marcus_sommer]

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

- Marcus

[sunny_talwar]

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?

[Anonymous]

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?

[raadwiptec]

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

[sunny_talwar]

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

[raadwiptec]

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

[sunny_talwar]

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

[Colin-Albert]

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

[raadwiptec]

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

];