Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

david_ze
Not applicable

How to...creat one table out of two.

Hi All
I have two tables:
tab_1:
my_number
1

2

3

tab_2:

my_latter

A

B

C

I would like to creat new table as follows:

1A

2A

3A

1B

2B

3B

1C

2C

3C

will appreciate your help on the script i should use to do this.

thanks in advanced,

David

1 Solution

Accepted Solutions
swuehl
Not applicable

How to...creat one table out of two.

Hi David,

maybe like this?

tab_1:

LOAD  * INLINE [

my_number

1

2

3

];

tab_2:

LOAD * INLINE [

my_latter

A

B

C

];

tmpResult:

NOCONCATENATE LOAD * resident tab_2;

inner join (tmpResult) LOAD *

resident tab_1;

Result:

LOAD my_number & my_latter as result resident tmpResult;

drop table tmpResult;

Hope this helps,

Stefan

3 Replies
swuehl
Not applicable

How to...creat one table out of two.

Hi David,

maybe like this?

tab_1:

LOAD  * INLINE [

my_number

1

2

3

];

tab_2:

LOAD * INLINE [

my_latter

A

B

C

];

tmpResult:

NOCONCATENATE LOAD * resident tab_2;

inner join (tmpResult) LOAD *

resident tab_1;

Result:

LOAD my_number & my_latter as result resident tmpResult;

drop table tmpResult;

Hope this helps,

Stefan

its_anandrjs
Not applicable

How to...creat one table out of two.

Hi David,

I suggest you have to load some thing like

tab_1:

LOAD  * INLINE [

my_number

1

2

3

];

tab_2:

LOAD * INLINE [

my_latter

A

B

C

];

 

Temp:

load

my_latter as Letters

Resident tab_2;

 

join

Load

my_number as Numbers

Resident tab_1;

   

Main:

load

Letters&Numbers as NewField

Resident Temp;

 

Drop tables tab_1,tab_2;

Rgds

Anand

david_ze
Not applicable

How to...creat one table out of two.

Thanks Stefan and Anand for the right answer.
David