Joins

[#1]

I have attached a Qlikview file with the following tables:

Test:

load * inline

[Entry No, Ref

101, 106

102, 107

103, 108

104, 109

105, 110];

Number:

load * inline

[Entry No, ItemNo

101, 11123

102, 11124];

Number1:

load * inline

[Entry No, ItemNo

103, 11125

104, 11126

105, 11127];

Desc:

load * inline

[ItemNo, Desc

11123, AAA

11124, BBB

11125, CCC

11126, DDD

11127, EEE];

I want the output as follows:

But it should be loaded as a single file. for example, i can link the common fields and prepare a new table.

But i want to use concatenate and joins and then load as a single file.

i am able to do if i have only one 'number' table. because i have two tables - (number and number1), i am not able to do it.

[PradeepReddy]

please find the attached application...

[#3]

Hi kartik,

Please find the below script

Test:
load * inline
[Entry No, Ref
101, 106
102, 107
103, 108
104, 109
105, 110];


Number:
load * inline
[Entry No, ItemNo
101, 11123
102, 11124];

Number1:
load * inline
[Entry No, ItemNo
103, 11125
104, 11126
105, 11127];

Left Join(Test)
LOAD
*
,'aa' as flag
Resident Number;
DROP Table Number;

left Join(Test)
Desc:
load * inline
[ItemNo, Desc
11123, AAA
11124, BBB
11125, CCC
11126, DDD
11127, EEE];

DROP Field flag from Test;

Regards

$@M

[#4]

Hi Kartik,

Please find the attached file. I guess you wanted it as a single table.

I am getting the output as required by you.

Hope it helps.

Regards,

Shashidhar

[jagan]

Hi,

Try this script

Test:

load * inline

[Entry No, Ref

101, 106

102, 107

103, 108

104, 109

105, 110];

Number:

load * inline

[Entry No, ItemNo

101, 11123

102, 11124];

Concatenate(Number)

load * inline

[Entry No, ItemNo

103, 11125

104, 11126

105, 11127];

Desc:

load * inline

[ItemNo, Desc

11123, AAA

11124, BBB

11125, CCC

11126, DDD

11127, EEE];

Now use Table box to display all the fields and you will get the required format.  If you want you can Join all the tables and convert it into single table.

Regards,

Jagan.

[#6]

But Jagan,

It has three tables linked to one another.

I wanted a single table.

[#7]

Hi,

PFA,

[#8]

hi karthik

see the script what I have posted.

it gives you what you want exactly.

Regards

$@M

[PradeepReddy]

check the application which I posted earlier.. hope it caters  your requirement..

[PrashantSangle]

Hi,

Try like,

Number:

load * inline

[Entry No, ItemNo

101, 11123

102, 11124];

Concatenate

load * inline

[Entry No, ItemNo

103, 11125

104, 11126

105, 11127];

join

load * inline

[ItemNo, Desc

11123, AAA

11124, BBB

11125, CCC

11126, DDD

11127, EEE];

Final

load * inline

[Entry No, Ref

101, 106

102, 107

103, 108

104, 109

105, 110];

join

load *

Resident Number;

Drop table Number;

Regards